/*
 Navicat Premium Data Transfer

 Source Server         : 106.13.139.113
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 106.13.139.113:3306
 Source Schema         : renren-fast

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 05/01/2020 02:17:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', '0 0 0 * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', NULL, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000016D7D9EF16A7874000E302F3330202A202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740005706172616D740018E5AE9AE697B6E6B885E79086E587BAE999A2E682A3E88085737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('RenrenScheduler', 'instance-b1rmdzyz1571549476373', 1578161878344, 15000);
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('RenrenScheduler', 'instance-gtc4byuu1570126686172', 1578161876503, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', NULL, 1578240000000, 1578153600000, 5, 'WAITING', 'CRON', 1569770631000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7074000B3020302030202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000274000131740018E5AE9AE697B6E6B885E79086E587BAE999A2E682A3E88085737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0011000000007800);
COMMIT;

-- ----------------------------
-- Table structure for bs_department
-- ----------------------------
DROP TABLE IF EXISTS `bs_department`;
CREATE TABLE `bs_department` (
  `department_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '科室ID',
  `department_name` varchar(255) NOT NULL COMMENT '科室名称',
  `department_remark` varchar(255) DEFAULT NULL COMMENT '科室备注',
  `is_frozen` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否冻结(0未冻结 1已冻结)',
  `hospital_id` bigint(20) NOT NULL COMMENT '医院ID',
  PRIMARY KEY (`department_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of bs_department
-- ----------------------------
BEGIN;
INSERT INTO `bs_department` VALUES (8, '外科', '', 0, 4);
INSERT INTO `bs_department` VALUES (9, '眼科', '', 0, 5);
INSERT INTO `bs_department` VALUES (10, '住院部', '', 0, 6);
INSERT INTO `bs_department` VALUES (11, '测试读卡', '测试', 0, 5);
INSERT INTO `bs_department` VALUES (12, '外科', '', 0, 5);
INSERT INTO `bs_department` VALUES (13, '测试室刷新', '', 0, 5);
INSERT INTO `bs_department` VALUES (14, '测试添加管理员', '', 0, 5);
INSERT INTO `bs_department` VALUES (15, '骨科', '', 0, 4);
INSERT INTO `bs_department` VALUES (16, '脑外科', '', 0, 4);
INSERT INTO `bs_department` VALUES (17, '住院部', '', 0, 7);
INSERT INTO `bs_department` VALUES (18, '产科病房', '产科病房', 0, 8);
INSERT INTO `bs_department` VALUES (19, '妇科病房', '妇科病房', 0, 8);
INSERT INTO `bs_department` VALUES (20, '产科病房二', '产科病房二', 0, 8);
INSERT INTO `bs_department` VALUES (21, '儿科病房', '儿科病房', 0, 8);
INSERT INTO `bs_department` VALUES (22, '乳腺病房', '乳腺病房', 0, 8);
COMMIT;

-- ----------------------------
-- Table structure for bs_department_administrator
-- ----------------------------
DROP TABLE IF EXISTS `bs_department_administrator`;
CREATE TABLE `bs_department_administrator` (
  `department_administrator_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '科室管理员ID',
  `administrator_account` varchar(255) NOT NULL COMMENT '管理员账号',
  `administrator_pwd` varchar(255) NOT NULL COMMENT '管理员密码',
  `administrator_nickname` varchar(255) DEFAULT NULL COMMENT '管理员昵称',
  `administrator_remark` varchar(255) DEFAULT NULL COMMENT '管理员备注',
  `administrator_contact_phone` varchar(255) DEFAULT NULL COMMENT '管理员联系电话',
  `administrator_wechat` varchar(255) DEFAULT NULL COMMENT '管理员微信',
  `department_id` bigint(20) NOT NULL COMMENT '科室ID',
  `salt` varchar(255) NOT NULL COMMENT '密码加密盐',
  PRIMARY KEY (`department_administrator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_department_administrator
-- ----------------------------
BEGIN;
INSERT INTO `bs_department_administrator` VALUES (3, 'ceshi', 'f30c33e4d8cd36068ef907c6b6f9e3aa5bc3429190d21a2fbb07463b610a53ae', '测试管理员账号', '', '', '', 8, 'Kvosnfqm52g8rn6KYL5w');
INSERT INTO `bs_department_administrator` VALUES (4, 'xyyyk', 'bef208e017e553435ac790638acce1790ff6854d56cfacb3a2e7ad89e15838bb', '县医院眼科', '', '', '', 9, 'rK58DrQndKP5puihyQIZ');
INSERT INTO `bs_department_administrator` VALUES (5, 'hshzyb', '260230816ba0debc868866a100b64d690b1dc6bda8de3bf6b1f5cfbc06faf982', '虎什哈住院部', '', '', '', 10, '7Fj3rKlmC0hW3CdSeMaj');
INSERT INTO `bs_department_administrator` VALUES (6, 'zyywk', 'be71eaeaef45ca764868bef4d8b95b9fff3957151392c0c2d3febb70d225049a', '中医院外科', '', '15097891500', '', 8, 'dCqgKexl6hQQwXAWn6mw');
INSERT INTO `bs_department_administrator` VALUES (7, 'duka', '1fdd91a65ac54aa5d9aabe72430d905a329f8719c0724d757db1ba78a934b48a', '读卡', '', '', '', 11, 'zlgBZw1VUETSQ47zltRi');
INSERT INTO `bs_department_administrator` VALUES (8, 'zyygk', '0ad51c681767d80a83052944564f6083d59c22b1ba42398bfbcde31b591ff52c', '中医院骨科', '', '', '', 15, 'tUZpGBVv17Xum50vYgYT');
INSERT INTO `bs_department_administrator` VALUES (9, 'zhenyiyuan', '950305c9dc4416185daea2bf9631c9c43be8082a26060db7c9ed58c9e3404608', '滦平镇医院', '', '', '', 17, '7NZL09zzpSymC6naCR3I');
INSERT INTO `bs_department_administrator` VALUES (10, 'ckbf', 'd08b1053e4882af2a27cb2d271d663a967e26534b0f076255ecf833ad71c8ba1', '产科病房', '', '', '', 18, '4RbwsfmcAHHywkBYwBRZ');
INSERT INTO `bs_department_administrator` VALUES (11, 'ckbf2', '369711fd6ff6bee0f5e7cdb8ab09ac0308532fbba2f4dbb872a5e1ac0012d992', '产科病房二', '', '', '', 20, 'QviaxIndGqF9qWGKAK5x');
INSERT INTO `bs_department_administrator` VALUES (12, 'fkbf', 'de67be69151708db5703d014878230d82b57f2bef8d7dcdfc49063442586dd74', '妇科病房', '', '', '', 19, 'pkOz96Oh63VkLxDP8Pw0');
INSERT INTO `bs_department_administrator` VALUES (13, 'ekbf', '0aa4ff59e12d5e41d7d0cfa44654e5789cf21aac435a0906f69cd6ceb0c805d8', '儿科病房', '', '', '', 21, 'UZK8iSq60nEMXsyabN6d');
COMMIT;

-- ----------------------------
-- Table structure for bs_department_patient
-- ----------------------------
DROP TABLE IF EXISTS `bs_department_patient`;
CREATE TABLE `bs_department_patient` (
  `department_patient_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门患者映射ID',
  `patient_id` bigint(20) NOT NULL COMMENT '患者id',
  `department_id` bigint(20) NOT NULL COMMENT '部门id',
  `hospitalization_date` datetime NOT NULL COMMENT '住院时间',
  `leave_hospital_date` datetime DEFAULT NULL COMMENT '出院时间',
  `hospitalization_picture` varchar(255) DEFAULT NULL COMMENT '入院照片',
  `other_message` varchar(255) DEFAULT NULL COMMENT '其他信息',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `ward_number` varchar(20) DEFAULT NULL COMMENT '病室号',
  `bed_number` varchar(20) DEFAULT NULL COMMENT '病床号',
  `is_leave` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否出院0未出院1已出院',
  PRIMARY KEY (`department_patient_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1136 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_department_patient
-- ----------------------------
BEGIN;
INSERT INTO `bs_department_patient` VALUES (14, 21, 8, '2019-09-03 20:06:53', '2019-09-04 14:57:07', NULL, NULL, '', '662', '124', 1);
INSERT INTO `bs_department_patient` VALUES (17, 24, 8, '2019-09-03 20:53:46', '2019-09-04 14:56:32', NULL, NULL, '', '263', '888', 1);
INSERT INTO `bs_department_patient` VALUES (18, 25, 8, '2019-09-03 20:57:08', '2019-09-04 14:56:33', NULL, NULL, '', '得', '莫', 1);
INSERT INTO `bs_department_patient` VALUES (19, 26, 8, '2019-09-03 20:59:35', '2019-09-04 14:56:34', NULL, NULL, '测试一个', '哦', '44', 1);
INSERT INTO `bs_department_patient` VALUES (22, 29, 8, '2019-09-03 22:43:36', '2019-09-04 14:56:34', NULL, NULL, '', '1236', '466 好', 1);
INSERT INTO `bs_department_patient` VALUES (23, 30, 8, '2019-09-03 22:44:08', '2019-09-04 14:56:35', NULL, NULL, '涂抹均匀', '模一样', '摸一下', 1);
INSERT INTO `bs_department_patient` VALUES (25, 32, 8, '2019-09-03 22:44:44', '2019-09-04 10:44:39', NULL, NULL, '55688', '一下我的', '看看', 1);
INSERT INTO `bs_department_patient` VALUES (26, 33, 8, '2019-09-03 22:45:13', '2019-09-04 14:56:38', NULL, NULL, '55', '哦哦哦哦哦哦', '规规矩矩', 1);
INSERT INTO `bs_department_patient` VALUES (27, 34, 8, '2019-09-03 22:47:54', '2019-09-04 14:56:39', NULL, NULL, '115看看', '445', '5556', 1);
INSERT INTO `bs_department_patient` VALUES (28, 35, 8, '2019-09-03 22:58:58', '2019-09-04 14:57:05', NULL, NULL, '', '103', '5', 1);
INSERT INTO `bs_department_patient` VALUES (29, 36, 8, '2019-09-04 09:33:48', '2019-09-04 14:56:40', NULL, NULL, '', '105', '12', 1);
INSERT INTO `bs_department_patient` VALUES (42, 49, 8, '2019-09-04 14:05:30', '2019-09-04 14:52:56', NULL, NULL, '', '105', '11', 1);
INSERT INTO `bs_department_patient` VALUES (43, 50, 8, '2019-09-04 14:06:15', '2019-09-04 14:56:52', NULL, NULL, '', '105', '5', 1);
INSERT INTO `bs_department_patient` VALUES (44, 51, 8, '2019-09-04 15:12:42', '2019-09-04 15:16:50', NULL, NULL, '', '23', '66', 1);
INSERT INTO `bs_department_patient` VALUES (45, 52, 8, '2019-09-04 15:12:53', '2019-09-04 15:16:48', NULL, NULL, '223', '12', '112', 1);
INSERT INTO `bs_department_patient` VALUES (47, 54, 8, '2019-09-05 14:38:12', '2019-09-05 20:56:08', NULL, NULL, '', '45', '55', 1);
INSERT INTO `bs_department_patient` VALUES (53, 60, 8, '2019-09-05 20:39:45', NULL, NULL, NULL, '', '3', '1', 0);
INSERT INTO `bs_department_patient` VALUES (55, 62, 9, '2019-09-07 13:24:31', NULL, NULL, NULL, '', '106', '15', 0);
INSERT INTO `bs_department_patient` VALUES (56, 63, 8, '2019-09-24 17:53:08', NULL, NULL, NULL, '', '105', '2', 0);
INSERT INTO `bs_department_patient` VALUES (58, 65, 8, '2019-09-25 09:40:28', NULL, NULL, NULL, '', '12', '206', 0);
INSERT INTO `bs_department_patient` VALUES (69, 76, 9, '2019-10-05 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (73, 80, 8, '2019-10-05 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (75, 82, 9, '2019-10-07 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (78, 85, 17, '2019-10-11 00:00:00', '2019-10-19 10:20:02', NULL, NULL, '', '3室', '4床', 1);
INSERT INTO `bs_department_patient` VALUES (79, 86, 17, '2019-10-11 00:00:00', '2019-10-19 10:20:33', NULL, NULL, '', '2室', '3床', 1);
INSERT INTO `bs_department_patient` VALUES (80, 87, 17, '2019-10-11 00:00:00', '2019-10-19 10:20:29', NULL, NULL, '', '2室', '2床', 1);
INSERT INTO `bs_department_patient` VALUES (81, 88, 17, '2019-10-11 00:00:00', '2019-10-18 09:41:16', NULL, NULL, '', '2室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (82, 89, 17, '2019-10-11 00:00:00', '2019-10-20 10:34:29', NULL, NULL, '', '4室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (83, 90, 17, '2019-10-11 20:37:25', '2019-10-18 09:41:12', NULL, NULL, '', '5室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (84, 91, 17, '2019-10-11 20:39:48', '2019-10-19 10:20:05', NULL, NULL, '', '5室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (86, 93, 17, '2019-10-11 00:00:00', '2019-10-20 10:34:26', NULL, NULL, '', '2室', '4床', 1);
INSERT INTO `bs_department_patient` VALUES (96, 103, 17, '2019-10-16 00:00:00', '2019-10-25 18:08:20', NULL, NULL, '', '四室', '二床', 1);
INSERT INTO `bs_department_patient` VALUES (97, 104, 17, '2019-10-16 00:00:00', '2019-10-25 18:08:18', NULL, NULL, '', '四室', '三床', 1);
INSERT INTO `bs_department_patient` VALUES (98, 105, 17, '2019-10-17 00:00:00', '2019-10-26 10:34:30', NULL, NULL, '', '2室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (99, 106, 17, '2019-10-18 00:00:00', '2019-10-28 10:27:54', NULL, NULL, '', '五室', '1床', 1);
INSERT INTO `bs_department_patient` VALUES (100, 107, 19, '2019-10-18 00:00:00', '2019-12-09 15:17:59', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (101, 108, 18, '2019-10-19 00:00:00', '2019-12-09 16:02:13', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (102, 109, 18, '2019-10-19 00:00:00', '2019-12-09 16:01:57', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (110, 117, 18, '2019-10-20 00:00:00', '2019-12-09 16:01:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (112, 119, 18, '2019-10-19 00:00:00', '2019-12-09 16:01:54', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (113, 120, 17, '2019-10-20 00:00:00', '2019-10-23 10:23:28', NULL, NULL, '', '四室', '1', 1);
INSERT INTO `bs_department_patient` VALUES (118, 125, 19, '2019-10-20 00:00:00', '2019-12-09 15:17:56', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (123, 130, 19, '2019-10-21 00:00:00', '2019-12-09 15:17:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (127, 134, 19, '2019-10-21 00:00:00', '2019-12-09 15:17:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (150, 157, 20, '2019-10-23 00:00:00', '2019-12-09 15:22:09', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (151, 158, 20, '2019-10-23 00:00:00', '2019-10-23 15:45:29', NULL, NULL, '', '316', '14', 1);
INSERT INTO `bs_department_patient` VALUES (152, 159, 21, '2019-10-23 00:00:00', '2019-12-11 13:26:44', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (156, 163, 21, '2019-10-23 00:00:00', '2019-12-11 13:27:14', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (161, 168, 21, '2019-10-23 00:00:00', '2019-12-11 13:27:43', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (165, 172, 20, '2019-10-24 00:00:00', '2019-12-09 15:22:08', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (167, 174, 18, '2019-10-24 00:00:00', '2019-12-09 16:01:41', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (169, 176, 18, '2019-10-24 00:00:00', '2019-12-09 16:01:39', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (171, 178, 21, '2019-10-24 00:00:00', '2019-12-11 13:28:04', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (177, 184, 19, '2019-10-25 00:00:00', '2019-12-09 15:17:53', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (181, 188, 18, '2019-10-25 00:00:00', '2019-12-09 16:01:36', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (196, 203, 20, '2019-10-26 00:00:00', '2019-12-09 15:22:04', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (197, 204, 18, '2019-10-27 00:00:00', '2019-12-09 16:01:34', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (198, 205, 21, '2019-10-27 00:00:00', '2019-12-11 13:29:22', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (199, 206, 18, '2019-10-27 00:00:00', '2019-12-09 16:01:33', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (200, 207, 21, '2019-10-27 00:00:00', '2019-12-11 13:30:23', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (208, 215, 18, '2019-10-28 00:00:00', '2019-12-09 16:01:30', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (210, 217, 20, '2019-10-28 00:00:00', '2019-12-09 15:22:03', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (211, 218, 20, '2019-10-28 00:00:00', '2019-12-09 15:22:03', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (213, 220, 20, '2019-10-28 00:00:00', '2019-12-09 15:22:02', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (221, 228, 20, '2019-10-28 00:00:00', '2019-12-09 15:22:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (223, 230, 20, '2019-10-28 00:00:00', '2019-12-09 15:21:59', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (227, 234, 20, '2019-10-29 00:00:00', '2019-12-09 15:21:54', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (236, 243, 21, '2019-10-29 00:00:00', '2019-12-11 13:30:32', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (237, 244, 22, '2019-10-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (238, 245, 21, '2019-10-29 00:00:00', '2019-12-11 13:30:42', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (239, 246, 21, '2019-10-29 00:00:00', '2019-12-09 16:00:48', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (241, 248, 21, '2019-10-29 00:00:00', '2019-12-11 13:30:49', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (244, 251, 20, '2019-10-29 00:00:00', '2019-12-09 15:21:52', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (249, 256, 21, '2019-10-30 00:00:00', '2019-12-11 13:31:14', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (253, 260, 20, '2019-10-30 00:00:00', '2019-12-09 15:21:51', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (254, 261, 21, '2019-10-30 00:00:00', '2019-12-11 13:31:25', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (257, 264, 21, '2019-10-31 00:00:00', '2019-12-11 13:33:06', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (258, 265, 20, '2019-10-31 00:00:00', '2019-12-09 15:21:50', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (262, 269, 21, '2019-10-31 00:00:00', '2019-12-11 13:26:13', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (275, 282, 21, '2019-10-31 00:00:00', '2019-12-11 13:33:29', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (291, 298, 18, '2019-11-01 00:00:00', '2019-12-09 16:01:18', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (292, 299, 18, '2019-11-01 00:00:00', '2019-12-09 16:01:18', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (293, 300, 21, '2019-11-02 00:00:00', '2019-12-11 13:34:54', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (301, 308, 21, '2019-11-02 00:00:00', '2019-12-11 13:35:40', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (302, 309, 20, '2019-11-02 00:00:00', '2019-12-09 15:21:38', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (304, 311, 20, '2019-11-03 00:00:00', '2019-12-09 15:21:37', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (305, 312, 18, '2019-11-03 00:00:00', '2019-12-09 16:01:17', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (306, 313, 18, '2019-11-03 00:00:00', '2019-12-09 16:01:16', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (316, 323, 20, '2019-11-04 00:00:00', '2019-12-09 15:21:35', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (317, 324, 21, '2019-11-04 00:00:00', '2019-12-11 13:36:51', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (326, 333, 20, '2019-11-04 00:00:00', '2019-12-09 15:21:33', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (348, 355, 21, '2019-11-05 00:00:00', '2019-12-09 16:01:47', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (349, 356, 21, '2019-11-05 00:00:00', '2019-12-11 13:37:26', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (350, 357, 18, '2019-11-05 00:00:00', '2019-12-09 16:01:08', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (353, 360, 21, '2019-11-06 00:00:00', '2019-12-11 13:37:35', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (359, 366, 20, '2019-11-06 00:00:00', '2019-12-09 15:20:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (373, 380, 21, '2019-11-07 00:00:00', '2019-12-11 13:37:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (376, 383, 18, '2019-11-07 00:00:00', '2019-12-09 16:00:37', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (379, 386, 18, '2019-11-08 00:00:00', '2019-12-09 16:00:37', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (389, 396, 20, '2019-11-08 00:00:00', '2019-12-09 15:20:47', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (392, 399, 17, '2019-11-09 00:00:00', '2019-11-22 11:54:43', NULL, NULL, '', '5', '1', 1);
INSERT INTO `bs_department_patient` VALUES (399, 406, 17, '2019-11-10 00:00:00', '2019-11-19 09:54:08', NULL, NULL, '', '4', '1', 1);
INSERT INTO `bs_department_patient` VALUES (403, 410, 21, '2019-11-10 00:00:00', '2019-12-09 16:17:52', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (404, 411, 21, '2019-11-10 00:00:00', '2019-12-11 13:38:20', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (405, 412, 17, '2019-11-10 00:00:00', '2019-11-20 16:26:00', NULL, NULL, '', '4', '2', 1);
INSERT INTO `bs_department_patient` VALUES (407, 414, 17, '2019-11-10 00:00:00', '2019-11-12 15:38:50', NULL, NULL, '', '3', '3', 1);
INSERT INTO `bs_department_patient` VALUES (408, 415, 20, '2019-11-11 00:00:00', '2019-12-09 15:20:43', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (417, 424, 18, '2019-11-11 00:00:00', '2019-12-09 16:00:30', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (419, 426, 22, '2019-11-11 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (420, 427, 18, '2019-11-11 00:00:00', '2019-12-09 16:00:28', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (421, 428, 18, '2019-11-11 00:00:00', '2019-12-09 16:00:27', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (423, 430, 18, '2019-11-11 00:00:00', '2019-12-09 16:00:27', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (426, 433, 17, '2019-11-12 00:00:00', '2019-11-20 09:57:01', NULL, NULL, '', '1', '2', 1);
INSERT INTO `bs_department_patient` VALUES (431, 438, 21, '2019-11-12 00:00:00', '2019-12-11 13:38:29', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (440, 447, 20, '2019-11-12 00:00:00', '2019-12-09 15:20:41', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (441, 448, 19, '2019-11-12 00:00:00', '2019-12-09 15:17:26', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (442, 449, 20, '2019-11-13 00:00:00', '2019-12-09 15:20:40', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (446, 453, 17, '2019-11-13 00:00:00', '2019-11-22 11:54:36', NULL, NULL, '', '2', '2', 1);
INSERT INTO `bs_department_patient` VALUES (454, 461, 18, '2019-11-13 00:00:00', '2019-12-09 16:00:26', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (457, 464, 21, '2019-11-14 00:00:00', '2019-12-09 16:00:09', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (458, 465, 21, '2019-11-14 00:00:00', '2019-12-09 15:59:22', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (459, 466, 18, '2019-11-14 00:00:00', '2019-12-09 16:00:24', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (460, 467, 21, '2019-11-14 00:00:00', '2019-12-11 13:38:34', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (471, 478, 18, '2019-11-15 00:00:00', '2019-12-09 16:00:23', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (472, 479, 18, '2019-11-15 00:00:00', '2019-12-09 16:00:22', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (476, 483, 18, '2019-11-15 00:00:00', '2019-12-09 16:00:21', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (480, 487, 21, '2019-11-16 00:00:00', '2019-12-11 13:38:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (481, 488, 21, '2019-11-16 00:00:00', '2019-12-11 13:38:41', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (482, 489, 20, '2019-11-16 00:00:00', '2019-12-09 15:20:35', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (490, 497, 20, '2019-11-17 00:00:00', '2019-12-09 15:20:28', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (492, 499, 18, '2019-11-17 00:00:00', '2019-12-09 16:00:16', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (496, 503, 18, '2019-11-17 00:00:00', '2019-12-09 16:00:13', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (501, 508, 21, '2019-11-18 00:00:00', '2019-12-09 15:59:32', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (507, 514, 21, '2019-11-18 00:00:00', '2019-12-09 15:57:19', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (509, 516, 20, '2019-11-18 00:00:00', '2019-12-09 15:20:23', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (524, 531, 21, '2019-11-20 00:00:00', '2019-12-11 13:39:04', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (525, 532, 21, '2019-11-20 00:00:00', '2019-12-11 13:39:09', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (526, 533, 18, '2019-11-20 00:00:00', '2019-12-09 16:00:10', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (527, 534, 17, '2019-11-20 00:00:00', '2019-11-29 10:38:55', NULL, NULL, '', '2', '2', 1);
INSERT INTO `bs_department_patient` VALUES (528, 535, 17, '2019-11-20 00:00:00', '2019-11-29 10:38:56', NULL, NULL, '', '4', '3', 1);
INSERT INTO `bs_department_patient` VALUES (529, 536, 21, '2019-11-20 00:00:00', '2019-12-11 13:39:15', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (541, 548, 21, '2019-11-20 00:00:00', '2019-12-09 16:18:01', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (542, 549, 21, '2019-11-20 00:00:00', '2019-12-09 15:54:31', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (545, 552, 19, '2019-11-20 00:00:00', '2019-12-09 15:17:16', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (547, 554, 18, '2019-11-21 00:00:00', '2019-12-09 16:00:05', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (551, 558, 19, '2019-11-21 00:00:00', '2019-12-09 15:17:15', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (553, 560, 21, '2019-11-21 00:00:00', '2019-12-11 13:39:21', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (556, 563, 21, '2019-11-22 00:00:00', '2019-12-09 15:57:27', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (562, 569, 20, '2019-11-22 00:00:00', '2019-12-09 15:20:18', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (565, 572, 20, '2019-11-22 00:00:00', '2019-12-09 15:20:17', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (568, 575, 21, '2019-11-23 00:00:00', '2019-12-09 16:17:27', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (571, 578, 17, '2019-11-23 00:00:00', '2019-11-29 10:38:49', NULL, NULL, '', '2', '2', 1);
INSERT INTO `bs_department_patient` VALUES (583, 590, 21, '2019-11-24 00:00:00', '2019-12-11 13:39:26', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (584, 591, 21, '2019-11-24 00:00:00', '2019-12-20 16:15:11', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (585, 592, 21, '2019-11-24 00:00:00', '2019-12-09 15:54:19', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (586, 593, 21, '2019-11-24 00:00:00', '2019-12-09 15:53:58', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (603, 610, 21, '2019-11-25 00:00:00', '2019-12-09 15:52:44', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (608, 615, 21, '2019-11-26 00:00:00', '2019-12-09 15:52:21', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (617, 624, 21, '2019-11-26 00:00:00', '2019-12-09 15:51:54', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (632, 639, 21, '2019-11-27 00:00:00', '2019-12-09 15:42:07', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (652, 659, 21, '2019-11-29 00:00:00', '2019-12-09 15:49:39', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (653, 660, 21, '2019-11-29 00:00:00', '2019-12-09 15:49:39', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (654, 661, 21, '2019-11-29 00:00:00', '2019-12-09 15:40:45', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (685, 692, 21, '2019-12-02 00:00:00', '2019-12-20 16:15:23', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (702, 709, 19, '2019-12-03 00:00:00', '2019-12-09 15:18:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (704, 711, 19, '2019-12-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (706, 713, 21, '2019-12-03 00:00:00', '2019-12-11 13:39:35', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (711, 718, 21, '2019-12-04 00:00:00', '2019-12-09 15:39:28', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (712, 719, 21, '2019-12-04 00:00:00', '2019-12-09 15:39:42', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (717, 724, 21, '2019-12-04 00:00:00', '2019-12-09 15:39:18', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (733, 740, 20, '2019-12-06 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (734, 741, 18, '2019-12-06 00:00:00', '2019-12-09 16:02:31', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (736, 743, 18, '2019-12-06 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (738, 745, 18, '2019-12-06 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (740, 747, 20, '2019-12-06 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (743, 750, 17, '2019-12-07 00:00:00', '2019-12-16 13:17:13', NULL, NULL, '', '1', '1', 1);
INSERT INTO `bs_department_patient` VALUES (745, 752, 21, '2019-12-07 00:00:00', '2019-12-11 13:39:47', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (746, 753, 18, '2019-12-07 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (747, 754, 18, '2019-12-07 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (748, 755, 21, '2019-12-07 00:00:00', '2019-12-09 16:01:18', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (753, 760, 18, '2019-12-07 00:00:00', '2019-12-09 15:32:04', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (754, 761, 18, '2019-12-08 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (756, 763, 21, '2019-12-08 00:00:00', '2019-12-11 13:40:14', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (758, 765, 21, '2019-12-08 00:00:00', '2019-12-20 16:15:04', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (761, 768, 20, '2019-12-09 00:00:00', '2019-12-09 15:21:08', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (762, 769, 17, '2019-12-11 11:09:27', '2019-12-18 12:25:03', NULL, NULL, '', '1', '2', 1);
INSERT INTO `bs_department_patient` VALUES (764, 771, 17, '2019-12-10 08:22:24', '2019-12-18 12:25:00', NULL, NULL, '', '2', '4', 1);
INSERT INTO `bs_department_patient` VALUES (766, 773, 21, '2019-12-05 00:00:00', '2019-12-11 13:40:07', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (767, 774, 21, '2019-12-06 00:00:00', '2019-12-20 16:17:37', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (770, 777, 21, '2019-12-05 00:00:00', '2019-12-20 16:15:58', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (775, 782, 21, '2019-12-09 00:00:00', '2019-12-20 16:17:03', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (776, 783, 19, '2019-12-09 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (778, 785, 18, '2019-12-09 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (779, 786, 21, '2019-12-09 00:00:00', '2019-12-20 16:17:13', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (780, 787, 18, '2019-12-09 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (781, 788, 21, '2019-12-09 00:00:00', '2019-12-20 16:17:48', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (783, 790, 18, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (784, 791, 18, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (785, 792, 18, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (787, 794, 18, '2019-12-09 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (789, 796, 19, '2019-12-09 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (790, 797, 21, '2019-12-09 00:00:00', '2019-12-20 16:18:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (791, 798, 17, '2019-12-10 00:00:00', '2019-12-20 10:28:34', NULL, NULL, '', '2', '5', 1);
INSERT INTO `bs_department_patient` VALUES (792, 799, 20, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (793, 800, 18, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (794, 801, 21, '2019-12-10 00:00:00', '2019-12-20 16:18:08', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (795, 802, 20, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (796, 803, 21, '2019-12-10 00:00:00', '2019-12-20 16:18:17', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (799, 806, 20, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (800, 807, 19, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (802, 809, 21, '2019-12-10 00:00:00', '2019-12-20 16:18:27', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (804, 811, 18, '2019-12-10 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (805, 812, 17, '2019-12-11 00:00:00', '2019-12-20 10:28:25', NULL, NULL, '', '3', '7', 1);
INSERT INTO `bs_department_patient` VALUES (806, 813, 21, '2019-12-11 00:00:00', '2019-12-30 11:31:20', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (807, 814, 21, '2019-12-11 00:00:00', '2019-12-20 16:18:47', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (808, 815, 21, '2019-12-11 00:00:00', '2019-12-20 16:19:01', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (811, 818, 21, '2019-12-11 00:00:00', '2019-12-20 16:16:11', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (816, 823, 19, '2019-12-11 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (819, 826, 18, '2019-12-11 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (820, 827, 18, '2019-12-11 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (821, 828, 18, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (822, 829, 18, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (823, 830, 21, '2019-12-12 00:00:00', '2019-12-20 16:19:38', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (826, 833, 20, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (827, 834, 19, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (828, 835, 18, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (829, 836, 21, '2019-12-12 00:00:00', '2019-12-30 11:31:45', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (831, 838, 20, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (833, 840, 21, '2019-12-12 00:00:00', '2019-12-30 11:32:26', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (834, 841, 21, '2019-12-12 00:00:00', '2019-12-30 11:32:07', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (835, 842, 20, '2019-12-12 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (837, 844, 21, '2019-12-13 00:00:00', '2019-12-20 16:19:15', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (838, 845, 17, '2019-12-13 00:00:00', '2019-12-24 16:29:21', NULL, NULL, '', '2', '6', 1);
INSERT INTO `bs_department_patient` VALUES (839, 846, 21, '2019-12-13 00:00:00', '2019-12-20 16:13:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (842, 849, 18, '2019-12-13 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (843, 850, 18, '2019-12-13 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (847, 854, 21, '2019-12-13 00:00:00', '2019-12-30 11:32:49', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (848, 855, 18, '2019-12-13 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (849, 856, 21, '2019-12-13 00:00:00', '2019-12-20 16:14:46', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (850, 857, 18, '2019-12-13 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (851, 858, 21, '2019-12-13 00:00:00', '2019-12-20 16:14:35', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (855, 862, 18, '2019-12-14 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (857, 864, 17, '2019-12-14 00:00:00', '2019-12-24 16:27:23', NULL, NULL, '', '3', '8', 1);
INSERT INTO `bs_department_patient` VALUES (859, 866, 21, '2019-12-14 00:00:00', '2019-12-30 11:33:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (860, 867, 20, '2019-12-14 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (861, 868, 21, '2019-12-14 00:00:00', '2019-12-20 16:14:23', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (862, 869, 21, '2019-12-14 00:00:00', '2019-12-20 16:14:01', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (863, 870, 20, '2019-12-14 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (865, 872, 19, '2019-12-14 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (867, 874, 21, '2019-12-14 00:00:00', '2019-12-30 11:33:40', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (870, 877, 20, '2019-12-15 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (871, 878, 20, '2019-12-15 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (872, 879, 20, '2019-12-15 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (873, 880, 21, '2019-12-15 00:00:00', '2019-12-30 11:34:03', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (875, 882, 21, '2019-12-15 00:00:00', '2019-12-30 11:34:28', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (876, 883, 21, '2019-12-15 00:00:00', '2019-12-30 11:34:17', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (877, 884, 21, '2019-12-15 00:00:00', '2019-12-30 11:34:38', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (878, 885, 18, '2019-12-15 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (879, 886, 21, '2019-12-15 00:00:00', '2019-12-20 16:13:16', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (885, 892, 21, '2019-12-16 00:00:00', '2019-12-30 11:35:13', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (887, 894, 21, '2019-12-16 00:00:00', '2019-12-20 16:13:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (888, 895, 20, '2019-12-16 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (890, 897, 20, '2019-12-16 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (891, 898, 18, '2019-12-16 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (893, 900, 18, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (895, 902, 21, '2019-12-17 00:00:00', '2019-12-30 11:35:55', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (897, 904, 18, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (898, 905, 21, '2019-12-17 00:00:00', '2019-12-30 11:35:24', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (899, 906, 20, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (900, 907, 18, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (901, 908, 22, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (903, 910, 18, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (904, 911, 20, '2019-12-17 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (906, 913, 18, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (907, 914, 21, '2019-12-18 00:00:00', '2019-12-30 11:36:09', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (908, 915, 18, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (910, 917, 21, '2019-12-18 00:00:00', '2019-12-30 11:36:19', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (911, 918, 20, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (913, 920, 19, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (915, 922, 18, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (916, 923, 20, '2019-12-18 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (918, 925, 18, '2019-12-19 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (920, 927, 21, '2019-12-19 00:00:00', '2019-12-30 11:36:53', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (922, 929, 21, '2019-12-19 00:00:00', '2019-12-30 11:37:17', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (923, 930, 18, '2019-12-19 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (925, 932, 18, '2019-12-19 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (926, 933, 19, '2019-12-19 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (930, 937, 17, '2019-12-20 00:00:00', '2019-12-31 11:35:38', NULL, NULL, '', '2', '2', 1);
INSERT INTO `bs_department_patient` VALUES (931, 938, 18, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (932, 939, 20, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (933, 940, 21, '2019-12-20 00:00:00', '2019-12-30 11:37:34', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (935, 942, 18, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (938, 945, 21, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (939, 946, 21, '2019-12-20 00:00:00', '2019-12-30 11:38:21', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (942, 949, 20, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (943, 950, 20, '2019-12-20 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (945, 952, 18, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (947, 954, 18, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (948, 955, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (949, 956, 21, '2019-12-21 00:00:00', '2019-12-31 13:54:44', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (950, 957, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (951, 958, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (952, 959, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (953, 960, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (954, 961, 21, '2019-12-21 00:00:00', '2019-12-31 13:54:59', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (955, 962, 21, '2019-12-21 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (957, 964, 21, '2019-12-22 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (958, 965, 21, '2019-12-22 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (959, 966, 21, '2019-12-22 00:00:00', '2019-12-30 11:38:28', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (960, 967, 20, '2019-12-22 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (962, 969, 19, '2019-12-22 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (963, 970, 20, '2019-12-22 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (964, 971, 19, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (965, 972, 20, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (967, 974, 21, '2019-12-23 00:00:00', '2019-12-31 13:54:20', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (968, 975, 21, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (969, 976, 19, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (970, 977, 21, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (971, 978, 21, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (972, 979, 20, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (973, 980, 19, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (975, 982, 18, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (976, 983, 21, '2019-12-23 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (977, 984, 17, '2019-12-24 00:00:00', NULL, NULL, NULL, '', '1', '3', 0);
INSERT INTO `bs_department_patient` VALUES (978, 985, 18, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (979, 986, 21, '2019-12-24 00:00:00', '2020-01-02 13:53:52', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (980, 987, 21, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (981, 988, 20, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (982, 989, 21, '2019-12-24 00:00:00', '2019-12-30 11:27:15', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (983, 990, 20, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (984, 991, 19, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (985, 992, 20, '2019-12-24 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (987, 994, 21, '2019-12-25 00:00:00', '2019-12-31 13:57:00', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (988, 995, 19, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (990, 997, 19, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (991, 998, 18, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (992, 999, 19, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (993, 1000, 18, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (995, 1002, 20, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (996, 1003, 21, '2019-12-25 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (997, 1004, 21, '2019-12-25 00:00:00', '2019-12-31 13:55:09', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (998, 1005, 18, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (999, 1006, 21, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1000, 1007, 21, '2019-12-26 00:00:00', '2019-12-30 11:38:44', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1001, 1008, 21, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1002, 1009, 20, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1003, 1010, 22, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1005, 1012, 18, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1006, 1013, 20, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1008, 1015, 21, '2019-12-26 00:00:00', '2019-12-31 13:57:40', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1009, 1016, 21, '2019-12-26 00:00:00', '2019-12-30 11:27:43', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1010, 1017, 21, '2019-12-26 00:00:00', '2019-12-30 11:39:08', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1011, 1018, 20, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1012, 1019, 21, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1013, 1020, 20, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1014, 1021, 21, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1018, 1025, 18, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1019, 1026, 20, '2019-12-26 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1020, 1027, 21, '2019-12-26 00:00:00', '2019-12-31 13:52:06', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1021, 1028, 21, '2019-12-27 00:00:00', '2019-12-30 11:27:02', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1022, 1029, 21, '2019-12-27 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1023, 1030, 21, '2019-12-27 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1024, 1031, 18, '2019-12-27 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1025, 1032, 19, '2019-12-27 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1026, 1033, 18, '2019-12-27 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1029, 1036, 21, '2019-12-28 00:00:00', '2019-12-31 13:53:21', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1030, 1037, 21, '2019-12-28 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1031, 1038, 19, '2019-12-28 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1032, 1039, 22, '2019-12-28 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1033, 1040, 21, '2019-12-28 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1034, 1041, 20, '2019-12-28 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1035, 1042, 20, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1037, 1044, 20, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1038, 1045, 20, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1039, 1046, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '2', '1', 0);
INSERT INTO `bs_department_patient` VALUES (1040, 1047, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '1', '1', 0);
INSERT INTO `bs_department_patient` VALUES (1041, 1048, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '1', '2', 0);
INSERT INTO `bs_department_patient` VALUES (1042, 1049, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '1', '3', 0);
INSERT INTO `bs_department_patient` VALUES (1043, 1050, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '2', '2', 0);
INSERT INTO `bs_department_patient` VALUES (1044, 1051, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '2', '3', 0);
INSERT INTO `bs_department_patient` VALUES (1045, 1052, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '3', '1', 0);
INSERT INTO `bs_department_patient` VALUES (1046, 1053, 17, '2019-12-29 00:00:00', NULL, NULL, NULL, '', '3', '2', 0);
INSERT INTO `bs_department_patient` VALUES (1047, 1054, 21, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1048, 1055, 21, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1049, 1056, 18, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1050, 1057, 21, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1051, 1058, 21, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1052, 1059, 18, '2019-12-29 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1053, 1060, 21, '2019-12-30 00:00:00', '2019-12-31 13:51:57', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1054, 1061, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1055, 1062, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1056, 1063, 19, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1057, 1064, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1058, 1065, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1059, 1066, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1061, 1068, 20, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1062, 1069, 21, '2019-12-30 00:00:00', '2019-12-31 13:52:59', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1063, 1070, 19, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1064, 1071, 18, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1065, 1072, 20, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1066, 1073, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1067, 1074, 21, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1068, 1075, 20, '2019-12-30 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1070, 1077, 17, '2019-12-31 00:00:00', NULL, NULL, NULL, '', '2', '2', 0);
INSERT INTO `bs_department_patient` VALUES (1071, 1078, 21, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1072, 1079, 21, '2019-12-31 00:00:00', '2020-01-02 13:53:01', NULL, '', '', '', '', 1);
INSERT INTO `bs_department_patient` VALUES (1073, 1080, 19, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1074, 1081, 21, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1075, 1082, 21, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1076, 1083, 21, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1077, 1084, 18, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1078, 1085, 19, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1080, 1087, 18, '2019-12-31 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1081, 1088, 19, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1082, 1089, 21, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1083, 1090, 21, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1084, 1091, 18, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1085, 1092, 20, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1086, 1093, 18, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1087, 1094, 18, '2020-01-01 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1088, 1095, 18, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1089, 1096, 18, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1091, 1098, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1092, 1099, 18, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1093, 1100, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1094, 1101, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1095, 1102, 22, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1096, 1103, 20, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1097, 1104, 19, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1098, 1105, 18, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1099, 1106, 18, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1100, 1107, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1101, 1108, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1102, 1109, 20, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1103, 1110, 20, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1104, 1111, 21, '2020-01-02 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1105, 1112, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1106, 1113, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1107, 1114, 19, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1108, 1115, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1109, 1116, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1110, 1117, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1111, 1118, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1112, 1119, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1113, 1120, 20, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1114, 1121, 19, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1115, 1122, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1116, 1123, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1117, 1124, 19, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1118, 1125, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1119, 1126, 19, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1120, 1127, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1121, 1128, 20, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1122, 1129, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1123, 1130, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1124, 1131, 21, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1125, 1132, 18, '2020-01-03 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1126, 1133, 21, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1127, 1134, 20, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1128, 1135, 19, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1129, 1136, 21, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1130, 1137, 21, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1131, 1138, 18, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1132, 1139, 18, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1133, 1140, 20, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1134, 1141, 21, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
INSERT INTO `bs_department_patient` VALUES (1135, 1142, 20, '2020-01-04 00:00:00', NULL, NULL, '', '', '', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for bs_department_patient_img
-- ----------------------------
DROP TABLE IF EXISTS `bs_department_patient_img`;
CREATE TABLE `bs_department_patient_img` (
  `department_patient_img_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '科室患者每天查房照片',
  `photograph_date` datetime DEFAULT NULL COMMENT '拍照日期',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `department_patient_id` bigint(20) NOT NULL COMMENT '部门患者ID',
  `extract_detail_patient_id` bigint(20) DEFAULT NULL COMMENT '抽取患者记录ID',
  `patient_img` varchar(255) DEFAULT NULL COMMENT '病人图片',
  `img_type` tinyint(2) NOT NULL COMMENT '照片类型 1入院时照片 2上报的照片',
  PRIMARY KEY (`department_patient_img_id`)
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_department_patient_img
-- ----------------------------
BEGIN;
INSERT INTO `bs_department_patient_img` VALUES (8, '2019-09-03 20:07:40', '2019-09-03 20:07:39', 14, NULL, '/picture/2019/09/d73309215ce84c308c030785d93d1eb6.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (11, '2019-09-03 20:53:48', '2019-09-03 20:53:47', 17, NULL, '/picture/2019/09/ad10f41442e5452193c904c77bf85dbc.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (12, '2019-09-03 20:57:10', '2019-09-03 20:57:09', 18, NULL, '/picture/2019/09/bc0a3cebab75426786563cafbba03cf1.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (13, '2019-09-03 20:59:37', '2019-09-03 20:59:37', 19, NULL, '/picture/2019/09/94837b510a17466e8d7c797e6726f256.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (16, '2019-09-03 22:43:38', '2019-09-03 22:43:38', 22, NULL, '/picture/2019/09/affe2964a3a94078b96e56a1d6abf369.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (17, '2019-09-03 22:44:10', '2019-09-03 22:44:09', 23, NULL, '/picture/2019/09/cd2139a668724fa193ffc9c893e9e05d.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (19, '2019-09-03 22:44:46', '2019-09-03 22:44:45', 25, NULL, '/picture/2019/09/ddd6fa734f7d463a98641ad1e57b2bdc.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (20, '2019-09-03 22:45:15', '2019-09-03 22:45:14', 26, NULL, '/picture/2019/09/dd75e284a46047c7b9420b39b030163e.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (21, '2019-09-03 22:47:57', '2019-09-03 22:47:56', 27, NULL, '/picture/2019/09/e25463eb9892432a9875a97f9293e38c.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (22, '2019-09-03 22:59:07', '2019-09-03 22:59:06', 28, NULL, '/picture/2019/09/97014b33c45e47299cded2cd2911f37a.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (23, '2019-09-04 09:33:50', '2019-09-04 09:33:49', 29, NULL, '/picture/2019/09/0f25ddef67ab4a3fb97c1a98663fe821.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (24, '2019-09-04 09:59:22', '2019-09-04 09:59:22', 25, 149, '/picture/2019/09/f37d4cf1929f43b3904b13f4d4829405.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (25, '2019-09-04 10:49:55', '2019-09-04 10:49:55', 29, 153, '/picture/2019/09/320bb191fbc444e08f9ba39080fc6e38.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (26, '2019-09-04 10:53:33', '2019-09-04 10:53:33', 28, 152, '/picture/2019/09/c800f25ab01f47f98b39ea19422a8668.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (28, '2019-09-04 10:58:16', '2019-09-04 10:58:15', 26, 150, '/picture/2019/09/5232d19613264fd28bc422043d6d5fda.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (29, '2019-09-04 12:16:57', '2019-09-04 12:16:57', 27, 151, '/picture/2019/09/c9242b78291d49449bd93f40037eda7e.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (41, '2019-09-04 14:05:31', '2019-09-04 14:05:30', 42, NULL, '/picture/2019/09/881023b423124d5fadf0c5e1073b876c.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (42, '2019-09-04 14:06:16', '2019-09-04 14:06:15', 43, NULL, '/picture/2019/09/9dac2ac88da84d7eb832c93149d9a5b4.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (43, '2019-09-04 14:14:59', '2019-09-04 14:14:58', 42, 154, '/picture/2019/09/af053c5b641742139cb592c2a07efe31.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (44, '2019-09-04 14:16:44', '2019-09-04 14:16:43', 43, 155, '/picture/2019/09/766d3581cc9141cab4126d2415fa94f4.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (49, '2019-09-04 15:12:44', '2019-09-04 15:12:43', 44, NULL, '/picture/2019/09/29e0eeed9f904b069f6d419d3d061342.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (50, '2019-09-04 15:12:54', '2019-09-04 15:12:54', 45, NULL, '/picture/2019/09/9a24a203ed56425b8132c98ca9e893a2.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (51, '2019-09-04 15:14:05', '2019-09-04 15:14:04', 44, 156, '/picture/2019/09/6119c293fbb94212b5a7bb678c0f5c5e.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (52, '2019-09-04 15:16:04', '2019-09-04 15:16:04', 45, 157, '/picture/2019/09/e1a6c232c57940bab2fad0ce757da058.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (54, '2019-09-05 11:00:41', '2019-09-05 11:00:40', 47, 158, '/picture/2019/09/bd2c16257c964f11bac9520c1db51708.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (55, '2019-09-05 14:38:14', '2019-09-05 14:38:14', 47, NULL, '/picture/2019/09/c1cbc2f967434b9d8aaf1b8bba822bcf.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (60, '2019-09-05 20:33:15', '2019-09-05 20:33:14', 47, 159, '/picture/2019/09/de5b7ad8a1e64711b234b73cffb1eac3.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (62, '2019-09-05 20:39:58', '2019-09-05 20:39:57', 53, NULL, '/picture/2019/09/73b816df6ff34f4b98a9da4e28154f6c.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (67, '2019-09-07 13:24:32', '2019-09-07 13:24:32', 55, NULL, '/picture/2019/09/52e07318a585485ebfcea7a3eea3e618.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (68, '2019-09-24 14:42:30', '2019-09-24 14:42:29', 55, NULL, '/picture/2019/09/73d6f6dbc1c44d65b3d76b74ee4dfa10.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (71, '2019-09-24 17:19:40', '2019-09-24 17:19:39', 53, NULL, '/picture/2019/09/706d63d8a99c42e592fe11945f6345f3.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (72, '2019-09-24 17:53:07', '2019-09-24 17:53:07', 56, NULL, '/picture/2019/09/25f37b096b464681bdea1a0799dd750d.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (73, '2019-09-24 18:47:45', '2019-09-24 18:47:45', 56, NULL, '/picture/2019/09/bef10f7744bb4b02a06d2b480891e9fc.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (77, '2019-09-25 09:40:29', '2019-09-25 09:40:28', 58, NULL, '/picture/2019/09/1db49b1941da4420b23aef44e1cf7f54.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (87, '2019-10-05 10:10:54', '2019-10-05 10:10:53', 73, NULL, '/picture/2019/10/4de34e8f6ba74023891057635da7fe7f.jpeg', 1);
INSERT INTO `bs_department_patient_img` VALUES (89, '2019-10-07 09:01:55', '2019-10-07 09:01:55', 75, NULL, '/picture/2019/10/0059d60aae9b438587f08508693db767.jpeg', 1);
INSERT INTO `bs_department_patient_img` VALUES (90, '2019-10-07 09:41:58', '2019-10-07 09:41:58', 73, NULL, '/picture/2019/10/0bcf76a040e541a9b43970b496931fb0.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (92, '2019-10-11 18:23:58', '2019-10-11 18:23:58', 78, NULL, '/picture/2019/10/4b83afde39af45a68a6866f066dc238d.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (93, '2019-10-11 18:26:35', '2019-10-11 18:26:35', 79, NULL, '/picture/2019/10/af9936482ec1411e86218a2904d257e0.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (94, '2019-10-11 18:28:04', '2019-10-11 18:28:03', 80, NULL, '/picture/2019/10/eecddccfce6049c19e8d84eb906fe5a0.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (95, '2019-10-11 18:29:59', '2019-10-11 18:29:59', 81, NULL, '/picture/2019/10/e13e25baa2c74484ad5bb556a97e6f92.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (96, '2019-10-11 18:37:50', '2019-10-11 18:37:50', 82, NULL, '/picture/2019/10/9f7414fb3e0442f9876db8d4594f8aad.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (101, '2019-10-11 20:37:26', '2019-10-11 20:37:26', 83, NULL, '/picture/2019/10/64372d8ff737456d8873c373d5391aaa.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (103, '2019-10-11 20:39:49', '2019-10-11 20:39:48', 84, NULL, '/picture/2019/10/ac898df34d9040e1b08c50eb59bdefb2.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (104, '2019-10-11 21:21:43', '2019-10-11 21:21:42', 86, NULL, '/picture/2019/10/355d339b20214ccbbe437c4a0d1f9c6e.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (109, '2019-10-14 15:31:39', '2019-10-14 15:31:39', 56, NULL, '/picture/2019/10/5c8fde434bcd465986c4c8bab1ecd82c.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (110, '2019-10-14 16:00:46', '2019-10-14 16:00:46', 86, 216, '/picture/2019/10/41e65de925204250a95109355ba69583.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (111, '2019-10-14 16:01:00', '2019-10-14 16:00:59', 81, 215, '/picture/2019/10/9aee63f1b6334bb29bf4419e011c12c8.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (117, '2019-10-16 16:17:33', '2019-10-16 16:17:32', 96, NULL, '/picture/2019/10/84f0b5cc248e4d7e94730d4cf11c938c.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (118, '2019-10-16 16:18:15', '2019-10-16 16:18:15', 97, NULL, '/picture/2019/10/629af75a46fa436eac15217e1877ab11.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (119, '2019-10-17 19:54:00', '2019-10-17 19:54:00', 98, NULL, '/picture/2019/10/85afb80a89dc442d94b5b0092bfb1ed4.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (120, '2019-10-18 11:43:08', '2019-10-18 11:43:08', 99, NULL, '/picture/2019/10/cb121b07d76e4424aa7d849b6d4e4cfe.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (122, '2019-10-20 13:05:20', '2019-10-20 13:05:20', 113, NULL, '/picture/2019/10/9511b013aa8c4241aa6dfe9956718c3b.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (126, '2019-10-23 15:45:17', '2019-10-23 15:45:16', 151, NULL, '/picture/2019/10/e0dcc9b74c7a4c97ad28dd08490b9add.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (145, '2019-11-09 11:22:47', '2019-11-09 11:22:46', 392, NULL, '/picture/2019/11/6bb4e82e754e4300b0318218cc81bae2.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (146, '2019-11-10 18:11:56', '2019-11-10 18:11:56', 399, NULL, '/picture/2019/11/31358d42825144eb8a1ad5542c73a658.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (147, '2019-11-10 18:38:46', '2019-11-10 18:38:45', 405, NULL, '/picture/2019/11/25b357f3845144a39fad1c6c78e22054.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (149, '2019-11-10 19:46:00', '2019-11-10 19:46:00', 407, NULL, '/picture/2019/11/1be51ba7b13c4f2ea77c7fe93092d071.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (150, '2019-11-11 14:59:24', '2019-11-11 14:59:23', 399, 220, '/picture/2019/11/e974420cc31c4f0e9ed6ec28f5ac45a8.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (151, '2019-11-11 14:59:45', '2019-11-11 14:59:45', 392, 219, '/picture/2019/11/3125c7d1e48c45e4a444620d5252ca00.jpg', 2);
INSERT INTO `bs_department_patient_img` VALUES (152, '2019-11-12 09:32:03', '2019-11-12 09:32:03', 426, NULL, '/picture/2019/11/269a640f4ba9444aa24ebceb123130eb.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (158, '2019-11-13 10:50:41', '2019-11-13 10:50:40', 446, NULL, '/picture/2019/11/eea79c29aabc468d885ab03df78a8c86.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (165, '2019-11-20 15:56:54', '2019-11-20 15:56:54', 527, NULL, '/picture/2019/11/74d687683eed42d3b67470c44f34d521.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (166, '2019-11-20 16:23:40', '2019-11-20 16:23:39', 528, NULL, '/picture/2019/11/abbc3175af93448fb5efe73569b40c6e.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (170, '2019-11-23 20:25:56', '2019-11-23 20:25:56', 571, NULL, '/picture/2019/11/8718a7c01a37463b9e9ee5ff4d9af46f.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (176, '2019-12-07 10:37:48', '2019-12-07 10:37:47', 743, NULL, '/picture/2019/12/94479e3422454cb5a52dd72c658bc179.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (187, '2019-12-10 08:22:22', '2019-12-10 08:22:22', 764, NULL, '/picture/2019/12/9f7296aede84409b94f9bba0e14d0b09.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (189, '2019-12-10 11:43:14', '2019-12-10 11:43:13', 791, NULL, '/picture/2019/12/f5f60cdd0ff44681b5127dcdd5e2f9c6.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (190, '2019-12-11 11:07:47', '2019-12-11 11:07:47', 805, NULL, '/picture/2019/12/89b56cbdd0eb4b67949458285dff4b8a.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (192, '2019-12-11 11:09:25', '2019-12-11 11:09:24', 762, NULL, '/picture/2019/12/e6dd280f5ad5424cb14e9f08db29bcde.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (193, '2019-12-13 11:27:04', '2019-12-13 11:27:03', 838, NULL, '/picture/2019/12/03674a1a01e44762a77bb630b38fd367.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (194, '2019-12-14 11:19:33', '2019-12-14 11:19:32', 857, NULL, '/picture/2019/12/7eee623aac3f4990bdecb8ed25544545.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (198, '2019-12-20 10:39:36', '2019-12-20 10:39:35', 930, NULL, '/picture/2019/12/4a58571661cb44dabd62d77d85768db8.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (199, '2019-12-24 11:30:57', '2019-12-24 11:30:56', 977, NULL, '/picture/2019/12/8873c698de6b4866acc10a044267728b.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (200, '2019-12-29 09:31:01', '2019-12-29 09:31:01', 1039, NULL, '/picture/2019/12/c00022a102bb4ffcb3b1ecb06337a2b9.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (201, '2019-12-29 09:31:43', '2019-12-29 09:31:43', 1040, NULL, '/picture/2019/12/c6269a8ab50742ef8ac136d3d517a96b.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (202, '2019-12-29 09:32:29', '2019-12-29 09:32:29', 1041, NULL, '/picture/2019/12/8eca5a1cfd004eeb981fcc5502fb6f9d.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (203, '2019-12-29 09:34:14', '2019-12-29 09:34:13', 1042, NULL, '/picture/2019/12/595f1545cc4047c3a425fd7b4fab8377.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (204, '2019-12-29 09:34:58', '2019-12-29 09:34:57', 1043, NULL, '/picture/2019/12/7e9551ece711405fa590f0b403718f06.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (205, '2019-12-29 09:35:45', '2019-12-29 09:35:44', 1044, NULL, '/picture/2019/12/c9c37adcb6d449d2971f500da0fe3551.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (206, '2019-12-29 09:36:26', '2019-12-29 09:36:26', 1045, NULL, '/picture/2019/12/c50e939851b84f5f8889c35a032901df.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (207, '2019-12-29 09:37:02', '2019-12-29 09:37:02', 1046, NULL, '/picture/2019/12/e93e7b26560240d6acb47347f3da987c.jpg', 1);
INSERT INTO `bs_department_patient_img` VALUES (208, '2019-12-31 11:36:26', '2019-12-31 11:36:25', 1070, NULL, '/picture/2019/12/9dd95ad84b674418b55995840d8579f1.jpg', 1);
COMMIT;

-- ----------------------------
-- Table structure for bs_extract_detail_patient
-- ----------------------------
DROP TABLE IF EXISTS `bs_extract_detail_patient`;
CREATE TABLE `bs_extract_detail_patient` (
  `extract_detail_patient_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '抽取详情患者ID',
  `detail_id` bigint(20) NOT NULL COMMENT '详情ID',
  `department_patient_id` bigint(20) NOT NULL COMMENT '患者住院ID',
  `is_done` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否完成(0未完成 1已完成)',
  PRIMARY KEY (`extract_detail_patient_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_extract_detail_patient
-- ----------------------------
BEGIN;
INSERT INTO `bs_extract_detail_patient` VALUES (149, 95, 25, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (150, 95, 26, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (151, 95, 27, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (152, 95, 28, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (153, 95, 29, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (154, 96, 42, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (155, 96, 43, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (156, 97, 44, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (157, 97, 45, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (158, 98, 47, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (159, 99, 47, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (215, 120, 81, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (216, 120, 86, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (219, 122, 392, 1);
INSERT INTO `bs_extract_detail_patient` VALUES (220, 122, 399, 1);
COMMIT;

-- ----------------------------
-- Table structure for bs_extract_detail_patient_handle
-- ----------------------------
DROP TABLE IF EXISTS `bs_extract_detail_patient_handle`;
CREATE TABLE `bs_extract_detail_patient_handle` (
  `extract_detail_patient_handle_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '处理ID',
  `detail_patient_id` bigint(20) NOT NULL COMMENT '详情患者id',
  `handle_img` varchar(255) NOT NULL COMMENT '处理图片',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`extract_detail_patient_handle_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_extract_detail_patient_handle
-- ----------------------------
BEGIN;
INSERT INTO `bs_extract_detail_patient_handle` VALUES (1, 117, '/picture/2019/08/7bc4bf1700924d53b1896742c657400c.jpg', '2019-08-26 14:27:14');
INSERT INTO `bs_extract_detail_patient_handle` VALUES (2, 118, '/picture/2019/08/7bc4bf1700924d53b1896742c657400c.jpg', '2019-08-26 14:27:22');
COMMIT;

-- ----------------------------
-- Table structure for bs_extract_record
-- ----------------------------
DROP TABLE IF EXISTS `bs_extract_record`;
CREATE TABLE `bs_extract_record` (
  `extract_record_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '抽取记录ID',
  `is_done` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0未完成 1已完成',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '抽取时间',
  `extract_type` tinyint(2) NOT NULL COMMENT '抽取类型(1随机抽取 2指定抽取)',
  PRIMARY KEY (`extract_record_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_extract_record
-- ----------------------------
BEGIN;
INSERT INTO `bs_extract_record` VALUES (119, 1, '2019-09-04 09:58:53', 2);
INSERT INTO `bs_extract_record` VALUES (120, 1, '2019-09-04 14:13:41', 2);
INSERT INTO `bs_extract_record` VALUES (121, 1, '2019-09-04 15:13:33', 2);
INSERT INTO `bs_extract_record` VALUES (122, 1, '2019-09-05 11:00:07', 2);
INSERT INTO `bs_extract_record` VALUES (123, 1, '2019-09-05 20:23:39', 2);
INSERT INTO `bs_extract_record` VALUES (137, 1, '2019-10-14 16:00:00', 2);
INSERT INTO `bs_extract_record` VALUES (139, 1, '2019-11-11 14:58:38', 2);
COMMIT;

-- ----------------------------
-- Table structure for bs_extract_record_detail
-- ----------------------------
DROP TABLE IF EXISTS `bs_extract_record_detail`;
CREATE TABLE `bs_extract_record_detail` (
  `extract_record_detail` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '抽取记录详情ID',
  `department_id` bigint(20) NOT NULL COMMENT '科室ID',
  `is_done` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否完成(0未完成 1已完成)',
  `record_id` bigint(20) NOT NULL COMMENT '记录ID',
  `extract_num` int(11) NOT NULL COMMENT '抽取数量',
  `hospital_id` bigint(20) NOT NULL COMMENT '医院ID',
  PRIMARY KEY (`extract_record_detail`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_extract_record_detail
-- ----------------------------
BEGIN;
INSERT INTO `bs_extract_record_detail` VALUES (95, 8, 1, 119, 5, 4);
INSERT INTO `bs_extract_record_detail` VALUES (96, 8, 1, 120, 2, 4);
INSERT INTO `bs_extract_record_detail` VALUES (97, 8, 1, 121, 2, 4);
INSERT INTO `bs_extract_record_detail` VALUES (98, 8, 1, 122, 1, 4);
INSERT INTO `bs_extract_record_detail` VALUES (99, 8, 1, 123, 1, 4);
INSERT INTO `bs_extract_record_detail` VALUES (120, 17, 1, 137, 2, 7);
INSERT INTO `bs_extract_record_detail` VALUES (122, 17, 1, 139, 2, 7);
COMMIT;

-- ----------------------------
-- Table structure for bs_hospital
-- ----------------------------
DROP TABLE IF EXISTS `bs_hospital`;
CREATE TABLE `bs_hospital` (
  `hospital_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '医院ID',
  `hospital_name` varchar(255) NOT NULL COMMENT '医院名称',
  `hospital_remark` varchar(255) DEFAULT NULL COMMENT '医院备注',
  `is_frozen` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否冻结(0未冻结 1已冻结)',
  PRIMARY KEY (`hospital_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='医院表';

-- ----------------------------
-- Records of bs_hospital
-- ----------------------------
BEGIN;
INSERT INTO `bs_hospital` VALUES (4, '滦平县中医院', '', 0);
INSERT INTO `bs_hospital` VALUES (5, '滦平县医院', '', 0);
INSERT INTO `bs_hospital` VALUES (6, '虎什哈医院', '', 0);
INSERT INTO `bs_hospital` VALUES (7, '滦平镇医院', '滦平镇医院', 0);
INSERT INTO `bs_hospital` VALUES (8, '滦平妇幼医院', '', 0);
COMMIT;

-- ----------------------------
-- Table structure for bs_patient
-- ----------------------------
DROP TABLE IF EXISTS `bs_patient`;
CREATE TABLE `bs_patient` (
  `patient_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '患者ID',
  `patient_name` varchar(20) NOT NULL COMMENT '姓名',
  `id_number` varchar(100) DEFAULT NULL COMMENT '身份证号',
  `gender` tinyint(2) NOT NULL COMMENT '性别1男2女',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`patient_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1143 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bs_patient
-- ----------------------------
BEGIN;
INSERT INTO `bs_patient` VALUES (21, '测试2', '', 1, '');
INSERT INTO `bs_patient` VALUES (24, '测试3', '', 1, '');
INSERT INTO `bs_patient` VALUES (25, '测试4', '', 2, '');
INSERT INTO `bs_patient` VALUES (26, '测试5', '130825199306120815', 1, '测试一个');
INSERT INTO `bs_patient` VALUES (29, '测试我', '', 1, '');
INSERT INTO `bs_patient` VALUES (30, '测试7', '138656', 1, '涂抹均匀');
INSERT INTO `bs_patient` VALUES (32, '测试8', '1256', 2, '55688');
INSERT INTO `bs_patient` VALUES (33, '测试9', '123', 1, '55');
INSERT INTO `bs_patient` VALUES (34, '测试10', '445哈哈', 1, '115看看');
INSERT INTO `bs_patient` VALUES (35, '啊啊啊', '55555', 1, '');
INSERT INTO `bs_patient` VALUES (36, '水电费', '1588938099', 1, '');
INSERT INTO `bs_patient` VALUES (49, '咯咯咯', '15097891500', 1, '');
INSERT INTO `bs_patient` VALUES (50, 'aaa', '', 1, '');
INSERT INTO `bs_patient` VALUES (51, '测试13', '130825199306120015', 2, '');
INSERT INTO `bs_patient` VALUES (52, '哈哈', '', 1, '');
INSERT INTO `bs_patient` VALUES (54, '风光好', '', 1, '');
INSERT INTO `bs_patient` VALUES (60, '李征', '130824199304044024', 1, '');
INSERT INTO `bs_patient` VALUES (62, '张三', '', 2, '');
INSERT INTO `bs_patient` VALUES (63, '电饭锅', '', 1, '');
INSERT INTO `bs_patient` VALUES (65, '张学友', '132626196908200518', 1, '');
INSERT INTO `bs_patient` VALUES (76, '大磊', '132626196908200518', 1, '');
INSERT INTO `bs_patient` VALUES (80, '孙伟             ', '131024198201151313', 1, '');
INSERT INTO `bs_patient` VALUES (82, '郭海林            ', '132626196908200517', 1, '');
INSERT INTO `bs_patient` VALUES (85, '方尚明', '', 1, '');
INSERT INTO `bs_patient` VALUES (86, '李俊生', '', 1, '');
INSERT INTO `bs_patient` VALUES (87, '韩俊伶', '', 1, '');
INSERT INTO `bs_patient` VALUES (88, '张义', '132626193607041011', 1, '');
INSERT INTO `bs_patient` VALUES (89, '王九洲', '', 1, '');
INSERT INTO `bs_patient` VALUES (90, '杨淑芹', '132626195404174024', 2, '');
INSERT INTO `bs_patient` VALUES (91, '王玉荣', '132626195901144029', 2, '');
INSERT INTO `bs_patient` VALUES (93, '田英', '', 1, '');
INSERT INTO `bs_patient` VALUES (103, '陈桂兰', '', 2, '');
INSERT INTO `bs_patient` VALUES (104, '张华芝', '', 2, '');
INSERT INTO `bs_patient` VALUES (105, '关金云', '', 1, '');
INSERT INTO `bs_patient` VALUES (106, '曹起', '', 1, '');
INSERT INTO `bs_patient` VALUES (107, '靳晓军', '130824199002176021', 2, '');
INSERT INTO `bs_patient` VALUES (108, '吴倩', '130824199312140024', 2, '');
INSERT INTO `bs_patient` VALUES (109, '张春羽', '130824199706224087', 2, '');
INSERT INTO `bs_patient` VALUES (117, '李佳美', '130824199406160026', 2, '');
INSERT INTO `bs_patient` VALUES (119, '刘芳', '130824199409010525', 2, '');
INSERT INTO `bs_patient` VALUES (120, '李金燕', '', 2, '');
INSERT INTO `bs_patient` VALUES (125, '孙晓青', '130824199611091541', 2, '');
INSERT INTO `bs_patient` VALUES (130, '刘凤月', '13262719691109672X', 2, '');
INSERT INTO `bs_patient` VALUES (134, '梁凤连', '132626197008161087', 2, '');
INSERT INTO `bs_patient` VALUES (157, '徐晓娜', '130824198612063548', 2, '');
INSERT INTO `bs_patient` VALUES (158, '苏红', '', 2, '');
INSERT INTO `bs_patient` VALUES (159, '万一德', '万一德', 1, '');
INSERT INTO `bs_patient` VALUES (163, '李常玲之女', '李常玲之女', 2, '');
INSERT INTO `bs_patient` VALUES (168, '郭艳秋之女', '郭艳秋之女', 2, '');
INSERT INTO `bs_patient` VALUES (172, '杨亚红', '610629199005235424', 2, '');
INSERT INTO `bs_patient` VALUES (174, '贺方圆', '130824199108293525', 2, '');
INSERT INTO `bs_patient` VALUES (176, '王老五', '132626197203103544', 2, '');
INSERT INTO `bs_patient` VALUES (178, '马鑫伊', '马鑫伊', 2, '');
INSERT INTO `bs_patient` VALUES (184, '王宏建', '13262619890922502X', 2, '');
INSERT INTO `bs_patient` VALUES (188, '刘芳', '刘芳', 2, '');
INSERT INTO `bs_patient` VALUES (203, '孟美玲', '21130319960126368X', 2, '');
INSERT INTO `bs_patient` VALUES (204, '娄莹莹', '130821198605188028', 2, '');
INSERT INTO `bs_patient` VALUES (205, '卢梦凡', '13082420141103602X', 2, '');
INSERT INTO `bs_patient` VALUES (206, '何小旭', '13082419920610154X', 2, '');
INSERT INTO `bs_patient` VALUES (207, '薛佳铭', '130824201001283028', 2, '');
INSERT INTO `bs_patient` VALUES (215, '褚凤梅', '130824198906173523', 2, '');
INSERT INTO `bs_patient` VALUES (217, '梁思彤', '13082420170929702X', 2, '');
INSERT INTO `bs_patient` VALUES (218, '王寒', '130824199411250042', 2, '');
INSERT INTO `bs_patient` VALUES (220, '胡亚利', '110222198801084840', 2, '');
INSERT INTO `bs_patient` VALUES (228, '康立欣', '132626198110074021', 2, '');
INSERT INTO `bs_patient` VALUES (230, '张国利', '130824199707193542', 2, '');
INSERT INTO `bs_patient` VALUES (234, '吴学利', '130824199001053564', 2, '');
INSERT INTO `bs_patient` VALUES (243, '张圻睿', '张圻睿', 1, '');
INSERT INTO `bs_patient` VALUES (244, '黄文贤', '130824197010250026', 2, '');
INSERT INTO `bs_patient` VALUES (245, '付雪颖之次子', '付雪颖之次子', 1, '');
INSERT INTO `bs_patient` VALUES (246, '付雪颖之长子', '付雪颖之长子', 1, '');
INSERT INTO `bs_patient` VALUES (248, '张正', '130824201312223516', 1, '');
INSERT INTO `bs_patient` VALUES (251, '乔宇涵', '130824199511303527', 2, '');
INSERT INTO `bs_patient` VALUES (256, '马鸣悦', '马鸣悦', 2, '');
INSERT INTO `bs_patient` VALUES (260, '周冰倩', '130824199712161529', 2, '');
INSERT INTO `bs_patient` VALUES (261, '王建强', '王建强', 1, '');
INSERT INTO `bs_patient` VALUES (264, '马一洋', '130824201704184034', 1, '');
INSERT INTO `bs_patient` VALUES (265, '金书敏', '130824198609214528', 2, '');
INSERT INTO `bs_patient` VALUES (269, '史宇明硕', '史宇明硕', 1, '');
INSERT INTO `bs_patient` VALUES (282, '宋梓晴', '130824201606203027', 2, '');
INSERT INTO `bs_patient` VALUES (298, '赵海倩', '130824199005291543', 2, '');
INSERT INTO `bs_patient` VALUES (299, '王海燕', '132626197909090044', 2, '');
INSERT INTO `bs_patient` VALUES (300, '贾彤硕之女', '贾彤硕之女', 2, '');
INSERT INTO `bs_patient` VALUES (308, '王雨萱', '王雨萱', 2, '');
INSERT INTO `bs_patient` VALUES (309, '刘若冰', '130824199203300025', 2, '');
INSERT INTO `bs_patient` VALUES (311, '王雷', '130824198904280026', 2, '');
INSERT INTO `bs_patient` VALUES (312, '丁星月', '130824199202143523', 2, '');
INSERT INTO `bs_patient` VALUES (313, '侯宝智', '130824199306073523', 2, '');
INSERT INTO `bs_patient` VALUES (323, '任文潼', '130821199408060046', 2, '');
INSERT INTO `bs_patient` VALUES (324, '邓宇轩', '邓宇轩', 1, '');
INSERT INTO `bs_patient` VALUES (333, '熊美丽', '532626199808052763', 2, '');
INSERT INTO `bs_patient` VALUES (355, '孟紫瑜', '孟紫瑜', 2, '');
INSERT INTO `bs_patient` VALUES (356, '刘欣惠', '刘欣惠', 2, '');
INSERT INTO `bs_patient` VALUES (357, '权世杰', '130824199512194027', 2, '');
INSERT INTO `bs_patient` VALUES (360, '张恩淇', '张恩淇', 2, '');
INSERT INTO `bs_patient` VALUES (366, '万瑞君', '130824199203121545', 2, '');
INSERT INTO `bs_patient` VALUES (380, '张新颖之女', '张新颖之女', 2, '');
INSERT INTO `bs_patient` VALUES (383, '吴玉云', '411522198804055728', 2, '');
INSERT INTO `bs_patient` VALUES (386, '张杰', '130824199107213028', 2, '');
INSERT INTO `bs_patient` VALUES (396, '吴栾', '130826199901255025', 2, '');
INSERT INTO `bs_patient` VALUES (399, '孙民', '', 1, '');
INSERT INTO `bs_patient` VALUES (406, '张秀霞', '', 2, '');
INSERT INTO `bs_patient` VALUES (410, '杨多硕', '130824201906150510', 1, '');
INSERT INTO `bs_patient` VALUES (411, '郭皓天', '郭皓天', 1, '');
INSERT INTO `bs_patient` VALUES (412, '王桂平', '', 2, '');
INSERT INTO `bs_patient` VALUES (414, '齐桂兰', '', 2, '');
INSERT INTO `bs_patient` VALUES (415, '吴晓慧', '132626199011295026', 2, '');
INSERT INTO `bs_patient` VALUES (424, '董铮', '130824199508256029', 2, '');
INSERT INTO `bs_patient` VALUES (426, '褚秀平', '13262619761119502X', 2, '');
INSERT INTO `bs_patient` VALUES (427, '朱海娟', '130828198208215920', 2, '');
INSERT INTO `bs_patient` VALUES (428, '李伟', '130824198706033542', 2, '');
INSERT INTO `bs_patient` VALUES (430, '高飞燕', '130824200302203525', 2, '');
INSERT INTO `bs_patient` VALUES (433, '李凤林', '', 1, '');
INSERT INTO `bs_patient` VALUES (438, '高梓鈊', '高梓鈊', 2, '');
INSERT INTO `bs_patient` VALUES (447, '王菲', '130803199507191022', 2, '');
INSERT INTO `bs_patient` VALUES (448, '杨飞飞', '130824199011015529', 2, '');
INSERT INTO `bs_patient` VALUES (449, '高凤英', '130824198007264528', 2, '');
INSERT INTO `bs_patient` VALUES (453, '王艳春', '', 1, '');
INSERT INTO `bs_patient` VALUES (461, '宋茂玉', '230122199204191628', 2, '');
INSERT INTO `bs_patient` VALUES (464, '及雪良之子', '及雪良之子', 1, '');
INSERT INTO `bs_patient` VALUES (465, '程思诺', '程思诺', 2, '');
INSERT INTO `bs_patient` VALUES (466, '李飞', '130724198507203427', 2, '');
INSERT INTO `bs_patient` VALUES (467, '王瀛诺', '130824201804280023', 2, '');
INSERT INTO `bs_patient` VALUES (478, '盘君艳', '450324199110105527', 2, '');
INSERT INTO `bs_patient` VALUES (479, '赵珍妮', '410725199709065825', 2, '');
INSERT INTO `bs_patient` VALUES (483, '杨淑女', '130824199001172029', 2, '');
INSERT INTO `bs_patient` VALUES (487, '杜雨竺', '杜雨竺', 2, '');
INSERT INTO `bs_patient` VALUES (488, '白皓宸', '130824201901310036', 1, '');
INSERT INTO `bs_patient` VALUES (489, '王亚琴', '622825199304190966', 2, '');
INSERT INTO `bs_patient` VALUES (497, '王明星', '130824198801020141', 2, '');
INSERT INTO `bs_patient` VALUES (499, '马雅贤', '130824197802193525', 2, '');
INSERT INTO `bs_patient` VALUES (503, '张凤姣', '130229199403312628', 2, '');
INSERT INTO `bs_patient` VALUES (508, '米承雨', '米承雨', 1, '');
INSERT INTO `bs_patient` VALUES (514, '王梓枭', '王梓枭', 2, '');
INSERT INTO `bs_patient` VALUES (516, '边雪柠', '130824199605060044', 2, '');
INSERT INTO `bs_patient` VALUES (531, '杨淑女之子', '杨淑女之子', 1, '');
INSERT INTO `bs_patient` VALUES (532, '郭燕玲之子', '郭燕玲之子', 1, '');
INSERT INTO `bs_patient` VALUES (533, '李敏', '李敏', 2, '');
INSERT INTO `bs_patient` VALUES (534, '赵凤林', '', 1, '');
INSERT INTO `bs_patient` VALUES (535, '张林', '', 1, '');
INSERT INTO `bs_patient` VALUES (536, '刘上官', '刘上官', 1, '');
INSERT INTO `bs_patient` VALUES (548, '孙佳', '孙佳', 2, '');
INSERT INTO `bs_patient` VALUES (549, '海语恩', '海语恩', 2, '');
INSERT INTO `bs_patient` VALUES (552, '董建辉', '132626198301150023', 2, '');
INSERT INTO `bs_patient` VALUES (554, '邓红红', '130824199405023521', 2, '');
INSERT INTO `bs_patient` VALUES (558, '李美佳', '13082419940207354X', 2, '');
INSERT INTO `bs_patient` VALUES (560, '高雪丽之女', '高雪丽之女', 2, '');
INSERT INTO `bs_patient` VALUES (563, '边雪柠之子', '边雪柠之子', 1, '');
INSERT INTO `bs_patient` VALUES (569, '张凯敏', '130824199608214520', 2, '');
INSERT INTO `bs_patient` VALUES (572, '聂丽红', '130828198808127721', 2, '');
INSERT INTO `bs_patient` VALUES (575, '张凯敏之女', '张凯敏之女', 2, '');
INSERT INTO `bs_patient` VALUES (578, '王苏枝', '', 2, '');
INSERT INTO `bs_patient` VALUES (590, '杨鑫语', '杨鑫语', 2, '');
INSERT INTO `bs_patient` VALUES (591, '李铭悦', '李铭悦', 2, '');
INSERT INTO `bs_patient` VALUES (592, '缪蕾', '130824201508130522', 2, '');
INSERT INTO `bs_patient` VALUES (593, '吴彤', '吴彤', 2, '');
INSERT INTO `bs_patient` VALUES (610, '刘雨函', '刘雨函', 2, '');
INSERT INTO `bs_patient` VALUES (615, '孙琪涵', '13082420150422402X', 2, '');
INSERT INTO `bs_patient` VALUES (624, '王永辉', '王永辉', 1, '');
INSERT INTO `bs_patient` VALUES (639, '高沂茉', '130824201801305520', 2, '');
INSERT INTO `bs_patient` VALUES (659, '詹子岩', '詹子岩', 2, '');
INSERT INTO `bs_patient` VALUES (660, '黄俊豪', '黄俊豪', 1, '');
INSERT INTO `bs_patient` VALUES (661, '孟美玲之女', '孟美玲之女', 2, '');
INSERT INTO `bs_patient` VALUES (692, '朱德源', '朱德源', 1, '');
INSERT INTO `bs_patient` VALUES (709, '吴亚杰', '130824198502033524', 2, '');
INSERT INTO `bs_patient` VALUES (711, '夏曼', '130824198712030022', 2, '');
INSERT INTO `bs_patient` VALUES (713, '李政阳', '130824201903286017', 1, '');
INSERT INTO `bs_patient` VALUES (718, '张悦之女', '张悦之女', 2, '');
INSERT INTO `bs_patient` VALUES (719, '赵梓润', '赵梓润', 1, '');
INSERT INTO `bs_patient` VALUES (724, '赵培之子', '赵培之子', 1, '');
INSERT INTO `bs_patient` VALUES (740, '刘晓丽', '130824198601023524', 2, '');
INSERT INTO `bs_patient` VALUES (741, '王红蕾', '130824199402080029', 2, '');
INSERT INTO `bs_patient` VALUES (743, '韩莹莹', '130824199112174027', 2, '');
INSERT INTO `bs_patient` VALUES (745, '周菲菲', '130824199207243021', 2, '');
INSERT INTO `bs_patient` VALUES (747, '马丽娜', '130824198912293521', 2, '');
INSERT INTO `bs_patient` VALUES (750, '梁秀平', '', 2, '');
INSERT INTO `bs_patient` VALUES (752, '沈羽萱', '沈羽萱', 2, '');
INSERT INTO `bs_patient` VALUES (753, '张楠', '130824198904150520', 2, '');
INSERT INTO `bs_patient` VALUES (754, '李丹', '131121199707093625', 2, '');
INSERT INTO `bs_patient` VALUES (755, '韩凝', '韩凝', 2, '');
INSERT INTO `bs_patient` VALUES (760, '姜凛然', '130824199007236046', 2, '');
INSERT INTO `bs_patient` VALUES (761, '郭春英', '13262619790419002X', 2, '');
INSERT INTO `bs_patient` VALUES (763, '辛瑷', '辛瑷', 2, '');
INSERT INTO `bs_patient` VALUES (765, '张楠之子', '张楠之子', 1, '');
INSERT INTO `bs_patient` VALUES (768, '闫晓红', '130824198612251020', 2, '');
INSERT INTO `bs_patient` VALUES (769, '张淑侠', '', 2, '');
INSERT INTO `bs_patient` VALUES (771, '王少琴', '', 2, '');
INSERT INTO `bs_patient` VALUES (773, '沈羽航', '沈羽航', 2, '');
INSERT INTO `bs_patient` VALUES (774, '刘梓鑫', '130824201904093540', 2, '');
INSERT INTO `bs_patient` VALUES (777, '王子豪', '130824201106173511', 1, '');
INSERT INTO `bs_patient` VALUES (782, '赵一菲', '130824201510041529', 2, '');
INSERT INTO `bs_patient` VALUES (783, '董桂红', '130824197509200028', 2, '');
INSERT INTO `bs_patient` VALUES (785, '徐晓静', '13082419880102402X', 2, '');
INSERT INTO `bs_patient` VALUES (786, '宁欣尧', '宁欣尧', 2, '');
INSERT INTO `bs_patient` VALUES (787, '代鹏悦', '130824200110170060', 2, '');
INSERT INTO `bs_patient` VALUES (788, '陈诗琪', '130824201901143522', 2, '');
INSERT INTO `bs_patient` VALUES (790, '徐春燕', '130824199304180026', 2, '');
INSERT INTO `bs_patient` VALUES (791, '孟丽雪', '130824199001101546', 2, '');
INSERT INTO `bs_patient` VALUES (792, '韩雪梅', '130821199109283768', 2, '');
INSERT INTO `bs_patient` VALUES (794, '李海波', '130824198704123528', 2, '');
INSERT INTO `bs_patient` VALUES (796, '李雪', '210122199102122126', 2, '');
INSERT INTO `bs_patient` VALUES (797, '郭海月之子', '郭海月之子', 1, '');
INSERT INTO `bs_patient` VALUES (798, '聂桂芬', '', 2, '');
INSERT INTO `bs_patient` VALUES (799, '刘帅', '13062619960718582X', 2, '');
INSERT INTO `bs_patient` VALUES (800, '贾红棋', '130825199411302726', 2, '');
INSERT INTO `bs_patient` VALUES (801, '曹皓冉', '130824201806123531', 1, '');
INSERT INTO `bs_patient` VALUES (802, '陈萌', '130824198907091546', 2, '');
INSERT INTO `bs_patient` VALUES (803, '孟丽雪之子', '孟丽雪之子', 1, '');
INSERT INTO `bs_patient` VALUES (806, '马艳英', '132626198508185020', 2, '');
INSERT INTO `bs_patient` VALUES (807, '孟娜', '130824198711273022', 2, '');
INSERT INTO `bs_patient` VALUES (809, '曹智慧', '曹智慧', 2, '');
INSERT INTO `bs_patient` VALUES (811, '高云', '14260319951002202X', 2, '');
INSERT INTO `bs_patient` VALUES (812, '张福兴', '', 1, '');
INSERT INTO `bs_patient` VALUES (813, '张佳昊', '130824201905193017', 1, '');
INSERT INTO `bs_patient` VALUES (814, '兰佳岳', '130824201603055022', 2, '');
INSERT INTO `bs_patient` VALUES (815, '平宇彤', '平宇彤', 2, '');
INSERT INTO `bs_patient` VALUES (818, '王雨泽', '王雨泽', 1, '');
INSERT INTO `bs_patient` VALUES (823, '刘丽娜', '130824198404281049', 2, '');
INSERT INTO `bs_patient` VALUES (826, '孙伟辉', '132626199211015025', 2, '');
INSERT INTO `bs_patient` VALUES (827, '刘艳苹', '130824198909092040', 2, '');
INSERT INTO `bs_patient` VALUES (828, '曹胜男', '130824198508074044', 2, '');
INSERT INTO `bs_patient` VALUES (829, '张迎琪', '130824199104051545', 2, '');
INSERT INTO `bs_patient` VALUES (830, '王梓涵', '王梓涵', 1, '');
INSERT INTO `bs_patient` VALUES (833, '缪如新', '132626198306170525', 2, '');
INSERT INTO `bs_patient` VALUES (834, '姜品淑', '132626196506063549', 2, '');
INSERT INTO `bs_patient` VALUES (835, '王晓旭', '130824198907085541', 2, '');
INSERT INTO `bs_patient` VALUES (836, '卢禹婧', '卢禹婧', 2, '');
INSERT INTO `bs_patient` VALUES (838, '邓慧', '431002199610283461', 2, '');
INSERT INTO `bs_patient` VALUES (840, '曹胜男之子', '曹胜男之子', 1, '');
INSERT INTO `bs_patient` VALUES (841, '张茗皓', '130824201803310016', 1, '');
INSERT INTO `bs_patient` VALUES (842, '马欢', '130824198706011028', 2, '');
INSERT INTO `bs_patient` VALUES (844, '贾红棋之女', '贾红棋之女', 2, '');
INSERT INTO `bs_patient` VALUES (845, '王海荣', '', 2, '');
INSERT INTO `bs_patient` VALUES (846, '张迎琪之女', '张迎琪之女', 2, '');
INSERT INTO `bs_patient` VALUES (849, '吴艳艳', '130824198502271020', 2, '');
INSERT INTO `bs_patient` VALUES (850, '张艳', '130824199302210025', 2, '');
INSERT INTO `bs_patient` VALUES (854, '孙思阳', '孙思阳', 1, '');
INSERT INTO `bs_patient` VALUES (855, '姜雪姣', '130824198609196024', 2, '');
INSERT INTO `bs_patient` VALUES (856, '李天钰', '130824201303230511', 1, '');
INSERT INTO `bs_patient` VALUES (857, '刘宏英', '130821198810074548', 2, '');
INSERT INTO `bs_patient` VALUES (858, '王洪波', '130824201606180013', 1, '');
INSERT INTO `bs_patient` VALUES (862, '闫飞飞', '130824199010135529', 2, '');
INSERT INTO `bs_patient` VALUES (864, '文有', '', 1, '');
INSERT INTO `bs_patient` VALUES (866, '焦靖瑀', '130824201910301510', 1, '');
INSERT INTO `bs_patient` VALUES (867, '刘春雨', '230125199202200729', 2, '');
INSERT INTO `bs_patient` VALUES (868, '丁梓俊', '丁梓俊', 1, '');
INSERT INTO `bs_patient` VALUES (869, '闫飞飞之子', '闫飞飞之子', 1, '');
INSERT INTO `bs_patient` VALUES (870, '赵岩', '130824199809283020', 2, '');
INSERT INTO `bs_patient` VALUES (872, '程云凤', '130824198902074026', 2, '');
INSERT INTO `bs_patient` VALUES (874, '曹梓昂', '130824201710284015', 1, '');
INSERT INTO `bs_patient` VALUES (877, '张秀华', '130824198606266023', 2, '');
INSERT INTO `bs_patient` VALUES (878, '陈新', '130824198811280027', 2, '');
INSERT INTO `bs_patient` VALUES (879, '马丁', '130824198703020105', 2, '');
INSERT INTO `bs_patient` VALUES (880, '李政阳', '李政阳', 1, '');
INSERT INTO `bs_patient` VALUES (882, '袁新玮', '袁新玮', 1, '');
INSERT INTO `bs_patient` VALUES (883, '曹迪菲', '曹迪菲', 2, '');
INSERT INTO `bs_patient` VALUES (884, '樊宏博', '樊宏博', 1, '');
INSERT INTO `bs_patient` VALUES (885, '何佳', '511381199010076022', 2, '');
INSERT INTO `bs_patient` VALUES (886, '顾珺溪', '130824201803053021', 2, '');
INSERT INTO `bs_patient` VALUES (892, '宋佳凝', '宋佳凝', 2, '');
INSERT INTO `bs_patient` VALUES (894, '李梓祎', '130824201209201044', 2, '');
INSERT INTO `bs_patient` VALUES (895, '李娜', '130824198711233063', 2, '');
INSERT INTO `bs_patient` VALUES (897, '翁茜雅', '130828199508152428', 2, '');
INSERT INTO `bs_patient` VALUES (898, '杨显华', '132626197908300521', 2, '');
INSERT INTO `bs_patient` VALUES (900, '王静', '130824198601120041', 2, '');
INSERT INTO `bs_patient` VALUES (902, '范禹轩', '130824201701250016', 1, '');
INSERT INTO `bs_patient` VALUES (904, '卢松雪', '130825199208102024', 2, '');
INSERT INTO `bs_patient` VALUES (905, '杨显华之次女', '杨显华之次女', 2, '');
INSERT INTO `bs_patient` VALUES (906, '王海燕', '132626198509165048', 2, '');
INSERT INTO `bs_patient` VALUES (907, '曾令超', '130824199010061021', 2, '');
INSERT INTO `bs_patient` VALUES (908, '魏雪姗', '13082419890411356X', 2, '');
INSERT INTO `bs_patient` VALUES (910, '尹秀青', '130821198601175908', 2, '');
INSERT INTO `bs_patient` VALUES (911, '刘香玉', '130824199705063525', 2, '');
INSERT INTO `bs_patient` VALUES (913, '杨雪', '132626199501175027', 2, '');
INSERT INTO `bs_patient` VALUES (914, '马慧之女', '马慧之女', 2, '');
INSERT INTO `bs_patient` VALUES (915, '马慧', '340322199101106829', 2, '');
INSERT INTO `bs_patient` VALUES (917, '张梓童', '130824201903097013', 1, '');
INSERT INTO `bs_patient` VALUES (918, '张莹', '130824198609173025', 2, '');
INSERT INTO `bs_patient` VALUES (920, '邓桂荣', '130824196608170560', 2, '');
INSERT INTO `bs_patient` VALUES (922, '顾立娟', '130826199308087227', 2, '');
INSERT INTO `bs_patient` VALUES (923, '王晓燕', '13073219860529086X', 2, '');
INSERT INTO `bs_patient` VALUES (925, '王思琪', '130824198706194020', 2, '');
INSERT INTO `bs_patient` VALUES (927, '范陈阳', '范陈阳', 1, '');
INSERT INTO `bs_patient` VALUES (929, '曹琳雪', '曹琳雪', 2, '');
INSERT INTO `bs_patient` VALUES (930, '黄伶伶', '130824199401236044', 2, '');
INSERT INTO `bs_patient` VALUES (932, '王艳云', '130824199505303029', 2, '');
INSERT INTO `bs_patient` VALUES (933, '苗淑红', '130824198009103525', 2, '');
INSERT INTO `bs_patient` VALUES (937, '田秀芬', '', 2, '');
INSERT INTO `bs_patient` VALUES (938, '王欢', '132626199210155042', 2, '');
INSERT INTO `bs_patient` VALUES (939, '王玉杰', '130824199807165020', 2, '');
INSERT INTO `bs_patient` VALUES (940, '赵天赫', '赵天赫', 1, '');
INSERT INTO `bs_patient` VALUES (942, '曹美伶', '132626199411025025', 2, '');
INSERT INTO `bs_patient` VALUES (945, '刘艺涵', '刘艺涵', 2, '');
INSERT INTO `bs_patient` VALUES (946, '杨楠之女', '杨楠之女', 2, '');
INSERT INTO `bs_patient` VALUES (949, '李红照', '130822198804032524', 2, '');
INSERT INTO `bs_patient` VALUES (950, '傅华', '130824198501200044', 2, '');
INSERT INTO `bs_patient` VALUES (952, '于嘉琪', '130826199404272828', 2, '');
INSERT INTO `bs_patient` VALUES (954, '焦美伶', '130824199412061542', 2, '');
INSERT INTO `bs_patient` VALUES (955, '王瑾萱', '130824201608310029', 2, '');
INSERT INTO `bs_patient` VALUES (956, '周圣博', '周圣博', 1, '');
INSERT INTO `bs_patient` VALUES (957, '沈羽航', '沈羽航', 2, '');
INSERT INTO `bs_patient` VALUES (958, '王以沫', '王以沫', 2, '');
INSERT INTO `bs_patient` VALUES (959, '陈俊泽', '130824201512231019', 1, '');
INSERT INTO `bs_patient` VALUES (960, '刘溢洋', '刘溢洋', 1, '');
INSERT INTO `bs_patient` VALUES (961, '初建男', '初建男', 1, '');
INSERT INTO `bs_patient` VALUES (962, '王晓燕之子', '王晓燕之子', 1, '');
INSERT INTO `bs_patient` VALUES (964, '曾明轩', '13082420120306101X', 1, '');
INSERT INTO `bs_patient` VALUES (965, '郭瑞琪', '郭瑞琪', 1, '');
INSERT INTO `bs_patient` VALUES (966, '李红照之女', '李红照之女', 2, '');
INSERT INTO `bs_patient` VALUES (967, '陈严', '130824198701011029', 2, '');
INSERT INTO `bs_patient` VALUES (969, '朱雪仙', '530128199606094520', 2, '');
INSERT INTO `bs_patient` VALUES (970, '齐蕊', '130825198908154525', 2, '');
INSERT INTO `bs_patient` VALUES (971, '张丽丽', '150429198509082146', 2, '');
INSERT INTO `bs_patient` VALUES (972, '于旭雷', '130682198310211368', 2, '');
INSERT INTO `bs_patient` VALUES (974, '周琳贺', '13082420160511003X', 1, '');
INSERT INTO `bs_patient` VALUES (975, '李婧一', '李婧一', 2, '');
INSERT INTO `bs_patient` VALUES (976, '王晓兰', '132626197411042029', 2, '');
INSERT INTO `bs_patient` VALUES (977, '梁萱彤', '130824201910271526', 2, '');
INSERT INTO `bs_patient` VALUES (978, '刘家宁', '刘家宁', 1, '');
INSERT INTO `bs_patient` VALUES (979, '姚敏', '130828199509163727', 2, '');
INSERT INTO `bs_patient` VALUES (980, '牛冬梅', '13082419860802102X', 2, '');
INSERT INTO `bs_patient` VALUES (982, '高雪', '131002198907143421', 2, '');
INSERT INTO `bs_patient` VALUES (983, '卢松雪之女', '卢松雪之女', 2, '');
INSERT INTO `bs_patient` VALUES (984, '林桂芝', '', 2, '');
INSERT INTO `bs_patient` VALUES (985, '范海娟', '130824199111290026', 2, '');
INSERT INTO `bs_patient` VALUES (986, '周梓诺', '周梓诺', 2, '');
INSERT INTO `bs_patient` VALUES (987, '刘曦', '刘曦', 2, '');
INSERT INTO `bs_patient` VALUES (988, '孙彩莲', '622424199306192246', 2, '');
INSERT INTO `bs_patient` VALUES (989, '于子淼', '于子淼', 2, '');
INSERT INTO `bs_patient` VALUES (990, '李宏伟', '130824199707153022', 2, '');
INSERT INTO `bs_patient` VALUES (991, '杨燕', '130824198705070587', 2, '');
INSERT INTO `bs_patient` VALUES (992, '刘艳玲', '130824198803243023', 2, '');
INSERT INTO `bs_patient` VALUES (994, '任家泽', '任家泽', 1, '');
INSERT INTO `bs_patient` VALUES (995, '吴志银', '132626197303204027', 2, '');
INSERT INTO `bs_patient` VALUES (997, '杨亚静', '130824198801041540', 2, '');
INSERT INTO `bs_patient` VALUES (998, '高彩霞', '140622199003043325', 2, '');
INSERT INTO `bs_patient` VALUES (999, '张玉莲', '130824197709183525', 2, '');
INSERT INTO `bs_patient` VALUES (1000, '何梦迪', '13082419960213006X', 2, '');
INSERT INTO `bs_patient` VALUES (1002, '王丽', '130824198509091620', 2, '');
INSERT INTO `bs_patient` VALUES (1003, '曹博宣', '曹博宣', 1, '');
INSERT INTO `bs_patient` VALUES (1004, '杨梓萌', '杨梓萌', 2, '');
INSERT INTO `bs_patient` VALUES (1005, '徐贵芝', '360124198410092126', 2, '');
INSERT INTO `bs_patient` VALUES (1006, '曹皓冉', '130824201806123531', 1, '');
INSERT INTO `bs_patient` VALUES (1007, '呼延冀航', '呼延冀航', 1, '');
INSERT INTO `bs_patient` VALUES (1008, '何浩源', '130824201201080014', 1, '');
INSERT INTO `bs_patient` VALUES (1009, '王天晴', '130824199112160020', 2, '');
INSERT INTO `bs_patient` VALUES (1010, '杨金香', '132626197110153040', 2, '');
INSERT INTO `bs_patient` VALUES (1012, '李津', '130824199502081547', 2, '');
INSERT INTO `bs_patient` VALUES (1013, '谢雪征', '130824199412240049', 2, '');
INSERT INTO `bs_patient` VALUES (1015, '梁茗硕', '梁茗硕', 1, '');
INSERT INTO `bs_patient` VALUES (1016, '卢润尘', '卢润尘', 1, '');
INSERT INTO `bs_patient` VALUES (1017, '马紫怡', '马紫怡', 2, '');
INSERT INTO `bs_patient` VALUES (1018, '叶华磊', '130824199005213529', 2, '');
INSERT INTO `bs_patient` VALUES (1019, '高雨泽', '130824201805190513', 1, '');
INSERT INTO `bs_patient` VALUES (1020, '李胜男', '130824198704160548', 2, '');
INSERT INTO `bs_patient` VALUES (1021, '马梓豪', '马梓豪', 1, '');
INSERT INTO `bs_patient` VALUES (1025, '武春月', '130824199303030528', 2, '');
INSERT INTO `bs_patient` VALUES (1026, '于新志', '130824199202150547', 2, '');
INSERT INTO `bs_patient` VALUES (1027, '李胜男之女', '李胜男之女', 2, '');
INSERT INTO `bs_patient` VALUES (1028, '梁焱', '梁焱', 1, '');
INSERT INTO `bs_patient` VALUES (1029, '刘禹泽', '130824201810130515', 1, '');
INSERT INTO `bs_patient` VALUES (1030, '李闫泽', '130824201906047011', 1, '');
INSERT INTO `bs_patient` VALUES (1031, '孙亚男', '130322199105164269', 2, '');
INSERT INTO `bs_patient` VALUES (1032, '黄海侠', '132626197807053541', 2, '');
INSERT INTO `bs_patient` VALUES (1033, '梁利利', '130822198701206448', 2, '');
INSERT INTO `bs_patient` VALUES (1036, '邓可欣', '130824200810313528', 2, '');
INSERT INTO `bs_patient` VALUES (1037, '张锦希', '张锦希', 1, '');
INSERT INTO `bs_patient` VALUES (1038, '张品连', '13262619570512352X', 2, '');
INSERT INTO `bs_patient` VALUES (1039, '孙玉珠', '132626196604242524', 2, '');
INSERT INTO `bs_patient` VALUES (1040, '王俊杰之女', '王俊杰之女', 2, '');
INSERT INTO `bs_patient` VALUES (1041, '谢槟赢', '21132219900806008X', 2, '');
INSERT INTO `bs_patient` VALUES (1042, '郭亚娟', '13082119981207452X', 2, '');
INSERT INTO `bs_patient` VALUES (1044, '李欣', '130824199012270521', 2, '');
INSERT INTO `bs_patient` VALUES (1045, '徐明旭', '132626198606025020', 2, '');
INSERT INTO `bs_patient` VALUES (1046, '孙占树', '', 1, '');
INSERT INTO `bs_patient` VALUES (1047, '李玉兰', '', 2, '');
INSERT INTO `bs_patient` VALUES (1048, '陈孝平', '', 2, '');
INSERT INTO `bs_patient` VALUES (1049, '何桂芹', '', 2, '');
INSERT INTO `bs_patient` VALUES (1050, '张阳福', '', 1, '');
INSERT INTO `bs_patient` VALUES (1051, '白春东', '', 1, '');
INSERT INTO `bs_patient` VALUES (1052, '张义', '', 1, '');
INSERT INTO `bs_patient` VALUES (1053, '唐继先', '', 1, '');
INSERT INTO `bs_patient` VALUES (1054, '刘梓鑫', '130824201904093540', 2, '');
INSERT INTO `bs_patient` VALUES (1055, '张佳音', '130824201810153522', 2, '');
INSERT INTO `bs_patient` VALUES (1056, '牟婷婷', '622427199211061648', 2, '');
INSERT INTO `bs_patient` VALUES (1057, '韩明硕', '韩明硕', 1, '');
INSERT INTO `bs_patient` VALUES (1058, '王涵', '王涵', 2, '');
INSERT INTO `bs_patient` VALUES (1059, '马丽', '130802199008201445', 2, '');
INSERT INTO `bs_patient` VALUES (1060, '刘艳玲之子', '刘艳玲之子', 1, '');
INSERT INTO `bs_patient` VALUES (1061, '张茗畅', '张茗畅', 2, '');
INSERT INTO `bs_patient` VALUES (1062, '闫双瑀', '闫双瑀', 1, '');
INSERT INTO `bs_patient` VALUES (1063, '杜美艳', '132626198304282048', 2, '');
INSERT INTO `bs_patient` VALUES (1064, '谌妮妹之女', '谌妮妹之女', 2, '');
INSERT INTO `bs_patient` VALUES (1065, '李茗果', '130824201910040525', 2, '');
INSERT INTO `bs_patient` VALUES (1066, '牛伊一', '牛伊一', 2, '');
INSERT INTO `bs_patient` VALUES (1068, '张立新', '130824198912130044', 2, '');
INSERT INTO `bs_patient` VALUES (1069, '杨婉莹', '杨婉莹', 2, '');
INSERT INTO `bs_patient` VALUES (1070, '王冰雪', '132626197009263026', 2, '');
INSERT INTO `bs_patient` VALUES (1071, '姜海岩', '130824198709196048', 2, '');
INSERT INTO `bs_patient` VALUES (1072, '马俊茹', '130922198910061623', 2, '');
INSERT INTO `bs_patient` VALUES (1073, '王宗耀', '王宗耀', 1, '');
INSERT INTO `bs_patient` VALUES (1074, '鞠亦涵', '鞠亦涵', 2, '');
INSERT INTO `bs_patient` VALUES (1075, '董佳仪', '132626198909095026', 2, '');
INSERT INTO `bs_patient` VALUES (1077, '陈玉荣', '', 2, '');
INSERT INTO `bs_patient` VALUES (1078, '杨成铭', '130824201605136010', 1, '');
INSERT INTO `bs_patient` VALUES (1079, '蓥康', '蓥康', 1, '');
INSERT INTO `bs_patient` VALUES (1080, '王金云', '132626197004091026', 2, '');
INSERT INTO `bs_patient` VALUES (1081, '梁语菲', '梁语菲', 2, '');
INSERT INTO `bs_patient` VALUES (1082, '孙铭阳', '孙铭阳', 1, '');
INSERT INTO `bs_patient` VALUES (1083, '王金阳', '王金阳', 1, '');
INSERT INTO `bs_patient` VALUES (1084, '李莹', '130824199112240020', 2, '');
INSERT INTO `bs_patient` VALUES (1085, '杨英侠', '130823198909102521', 2, '');
INSERT INTO `bs_patient` VALUES (1087, '周丽新', '130824199005070062', 2, '');
INSERT INTO `bs_patient` VALUES (1088, '孔祥鹤', '130824199605183028', 2, '');
INSERT INTO `bs_patient` VALUES (1089, '曹晨', '130824201303190046', 2, '');
INSERT INTO `bs_patient` VALUES (1090, '贺淼', '贺淼', 2, '');
INSERT INTO `bs_patient` VALUES (1091, '李巍伟', '130824199405283526', 2, '');
INSERT INTO `bs_patient` VALUES (1092, '李小璇', '342201199312280020', 2, '');
INSERT INTO `bs_patient` VALUES (1093, '信冀红', '130824199104205524', 2, '');
INSERT INTO `bs_patient` VALUES (1094, '姚磊', '130724200310194125', 2, '');
INSERT INTO `bs_patient` VALUES (1095, '张桂萍', '371327199601120924', 2, '');
INSERT INTO `bs_patient` VALUES (1096, '李艳', '130824199307264022', 2, '');
INSERT INTO `bs_patient` VALUES (1098, '张博源', '张博源', 1, '');
INSERT INTO `bs_patient` VALUES (1099, '张艳丽', '13082419831219102X', 2, '');
INSERT INTO `bs_patient` VALUES (1100, '李莹之子', '李莹之子', 1, '');
INSERT INTO `bs_patient` VALUES (1101, '李思彤', '李思彤', 2, '');
INSERT INTO `bs_patient` VALUES (1102, '张桂君', '132626197007141084', 2, '');
INSERT INTO `bs_patient` VALUES (1103, '柴艳艳', '130824198509060023', 2, '');
INSERT INTO `bs_patient` VALUES (1104, '刘治华', '132626197010114028', 2, '');
INSERT INTO `bs_patient` VALUES (1105, '李娟', '132626199206255040', 2, '');
INSERT INTO `bs_patient` VALUES (1106, '赵海燕', '110228198709034128', 2, '');
INSERT INTO `bs_patient` VALUES (1107, '尹浩', '尹浩', 1, '');
INSERT INTO `bs_patient` VALUES (1108, '王伟泽', '王伟泽', 1, '');
INSERT INTO `bs_patient` VALUES (1109, '白新亚', '120225199106306021', 2, '');
INSERT INTO `bs_patient` VALUES (1110, '王颖聪', '130824198712023041', 2, '');
INSERT INTO `bs_patient` VALUES (1111, '许皓杰', '许皓杰', 1, '');
INSERT INTO `bs_patient` VALUES (1112, '张玲', '130824199201230529', 2, '');
INSERT INTO `bs_patient` VALUES (1113, '焦孙', '230506199004180723', 2, '');
INSERT INTO `bs_patient` VALUES (1114, '刘春艳', '130824199005083568', 2, '');
INSERT INTO `bs_patient` VALUES (1115, '范立梅', '130824198707231022', 2, '');
INSERT INTO `bs_patient` VALUES (1116, '焦孙之女', '焦孙之女', 2, '');
INSERT INTO `bs_patient` VALUES (1117, '李成', '130826199111245025', 2, '');
INSERT INTO `bs_patient` VALUES (1118, '王子皓', '王子皓', 1, '');
INSERT INTO `bs_patient` VALUES (1119, '王子铭', '王子铭', 1, '');
INSERT INTO `bs_patient` VALUES (1120, '王媛媛', '130824198610014048', 2, '');
INSERT INTO `bs_patient` VALUES (1121, '徐海莲', '130824199002262026', 2, '');
INSERT INTO `bs_patient` VALUES (1122, '解梓涵', '解梓涵', 2, '');
INSERT INTO `bs_patient` VALUES (1123, '姜天宇', '姜天宇', 1, '');
INSERT INTO `bs_patient` VALUES (1124, '李芳芳', '130824198711054022', 2, '');
INSERT INTO `bs_patient` VALUES (1125, '康春艳', '130824199402284048', 2, '');
INSERT INTO `bs_patient` VALUES (1126, '鞠晓红', '13262619860424502X', 2, '');
INSERT INTO `bs_patient` VALUES (1127, '王雨婷', '130824199006090022', 2, '');
INSERT INTO `bs_patient` VALUES (1128, '王静', '130824198601253522', 2, '');
INSERT INTO `bs_patient` VALUES (1129, '何春侠', '130826198605037627', 2, '');
INSERT INTO `bs_patient` VALUES (1130, '马宗环', '130824198105203526', 2, '');
INSERT INTO `bs_patient` VALUES (1131, '高铭洋', '高铭洋', 1, '');
INSERT INTO `bs_patient` VALUES (1132, '王敏', '411526198512264523', 2, '');
INSERT INTO `bs_patient` VALUES (1133, '张芮萌之子', '张芮萌之子', 1, '');
INSERT INTO `bs_patient` VALUES (1134, '武海燕', '130824199811280021', 2, '');
INSERT INTO `bs_patient` VALUES (1135, '郑秀玲', '132626197010261562', 2, '');
INSERT INTO `bs_patient` VALUES (1136, '李沐瑶', '李沐瑶', 2, '');
INSERT INTO `bs_patient` VALUES (1137, '乔昊天', '130128201908031213', 1, '');
INSERT INTO `bs_patient` VALUES (1138, '郑亚男', '130823198907172024', 2, '');
INSERT INTO `bs_patient` VALUES (1139, '康丽凤', '130823198906086087', 2, '');
INSERT INTO `bs_patient` VALUES (1140, '杨丽红', '132626199104225027', 2, '');
INSERT INTO `bs_patient` VALUES (1141, '黄天宝', '黄天宝', 1, '');
INSERT INTO `bs_patient` VALUES (1142, '薛璐璐', '130824199411071028', 2, '');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` VALUES (2, 'testTask', '1', '0 0 0 * * ?', 0, '定时清理出院患者', '2019-09-29 23:23:52');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job_log` VALUES (55, 2, 'testTask', '1', 0, NULL, 19, '2019-10-27 00:00:00');
INSERT INTO `schedule_job_log` VALUES (56, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 409, '2019-10-28 00:00:00');
INSERT INTO `schedule_job_log` VALUES (57, 2, 'testTask', '1', 0, NULL, 442, '2019-10-29 00:00:00');
INSERT INTO `schedule_job_log` VALUES (58, 2, 'testTask', '1', 0, NULL, 22, '2019-10-30 00:00:00');
INSERT INTO `schedule_job_log` VALUES (59, 2, 'testTask', '1', 0, NULL, 36, '2019-10-31 00:00:00');
INSERT INTO `schedule_job_log` VALUES (60, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 389, '2019-11-01 00:00:00');
INSERT INTO `schedule_job_log` VALUES (61, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 36, '2019-11-02 00:00:00');
INSERT INTO `schedule_job_log` VALUES (62, 2, 'testTask', '1', 0, NULL, 404, '2019-11-03 00:00:00');
INSERT INTO `schedule_job_log` VALUES (63, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 329, '2019-11-04 00:00:00');
INSERT INTO `schedule_job_log` VALUES (64, 2, 'testTask', '1', 0, NULL, 41, '2019-11-05 00:00:00');
INSERT INTO `schedule_job_log` VALUES (77, 2, 'testTask', '1', 0, NULL, 31, '2019-11-18 00:00:00');
INSERT INTO `schedule_job_log` VALUES (78, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 402, '2019-11-19 00:00:00');
INSERT INTO `schedule_job_log` VALUES (79, 2, 'testTask', '1', 0, NULL, 56, '2019-11-20 00:00:00');
INSERT INTO `schedule_job_log` VALUES (80, 2, 'testTask', '1', 0, NULL, 573, '2019-11-21 00:00:00');
INSERT INTO `schedule_job_log` VALUES (81, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 410, '2019-11-22 00:00:00');
INSERT INTO `schedule_job_log` VALUES (82, 2, 'testTask', '1', 0, NULL, 579, '2019-11-23 00:00:00');
INSERT INTO `schedule_job_log` VALUES (83, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 470, '2019-11-24 00:00:00');
INSERT INTO `schedule_job_log` VALUES (84, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 457, '2019-11-25 00:00:00');
INSERT INTO `schedule_job_log` VALUES (85, 2, 'testTask', '1', 0, NULL, 452, '2019-11-26 00:00:00');
INSERT INTO `schedule_job_log` VALUES (86, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 24, '2019-11-27 00:00:00');
INSERT INTO `schedule_job_log` VALUES (87, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 26, '2019-11-28 00:00:00');
INSERT INTO `schedule_job_log` VALUES (88, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 479, '2019-11-29 00:00:00');
INSERT INTO `schedule_job_log` VALUES (89, 2, 'testTask', '1', 0, NULL, 627, '2019-11-30 00:00:00');
INSERT INTO `schedule_job_log` VALUES (90, 2, 'testTask', '1', 0, NULL, 576, '2019-12-01 00:00:00');
INSERT INTO `schedule_job_log` VALUES (91, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 44, '2019-12-02 00:00:00');
INSERT INTO `schedule_job_log` VALUES (92, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 463, '2019-12-03 00:00:00');
INSERT INTO `schedule_job_log` VALUES (93, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 569, '2019-12-04 00:00:00');
INSERT INTO `schedule_job_log` VALUES (94, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 504, '2019-12-05 00:00:00');
INSERT INTO `schedule_job_log` VALUES (95, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 421, '2019-12-06 00:00:00');
INSERT INTO `schedule_job_log` VALUES (96, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 1941, '2019-12-07 00:00:00');
INSERT INTO `schedule_job_log` VALUES (97, 2, 'testTask', '1', 0, NULL, 567, '2019-12-08 00:00:00');
INSERT INTO `schedule_job_log` VALUES (98, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 466, '2019-12-09 00:00:00');
INSERT INTO `schedule_job_log` VALUES (99, 2, 'testTask', '1', 0, NULL, 1180, '2019-12-10 00:00:00');
INSERT INTO `schedule_job_log` VALUES (100, 2, 'testTask', '1', 0, NULL, 78, '2019-12-11 00:00:00');
INSERT INTO `schedule_job_log` VALUES (101, 2, 'testTask', '1', 0, NULL, 58, '2019-12-12 00:00:00');
INSERT INTO `schedule_job_log` VALUES (102, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 434, '2019-12-13 00:00:00');
INSERT INTO `schedule_job_log` VALUES (103, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 24, '2019-12-14 00:00:00');
INSERT INTO `schedule_job_log` VALUES (104, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 20, '2019-12-15 00:00:00');
INSERT INTO `schedule_job_log` VALUES (105, 2, 'testTask', '1', 0, NULL, 596, '2019-12-16 00:00:00');
INSERT INTO `schedule_job_log` VALUES (106, 2, 'testTask', '1', 0, NULL, 59, '2019-12-17 00:00:00');
INSERT INTO `schedule_job_log` VALUES (107, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 496, '2019-12-18 00:00:00');
INSERT INTO `schedule_job_log` VALUES (108, 2, 'testTask', '1', 0, NULL, 33, '2019-12-19 00:00:00');
INSERT INTO `schedule_job_log` VALUES (109, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 51, '2019-12-20 00:00:00');
INSERT INTO `schedule_job_log` VALUES (110, 2, 'testTask', '1', 0, NULL, 613, '2019-12-21 00:00:01');
INSERT INTO `schedule_job_log` VALUES (111, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 526, '2019-12-22 00:00:00');
INSERT INTO `schedule_job_log` VALUES (112, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 53, '2019-12-23 00:00:00');
INSERT INTO `schedule_job_log` VALUES (113, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 29, '2019-12-24 00:00:00');
INSERT INTO `schedule_job_log` VALUES (114, 2, 'testTask', '1', 0, NULL, 586, '2019-12-25 00:00:00');
INSERT INTO `schedule_job_log` VALUES (115, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 72, '2019-12-26 00:00:00');
INSERT INTO `schedule_job_log` VALUES (116, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 54, '2019-12-27 00:00:00');
INSERT INTO `schedule_job_log` VALUES (120, 2, 'testTask', '1', 0, NULL, 70, '2019-12-31 00:00:00');
INSERT INTO `schedule_job_log` VALUES (121, 2, 'testTask', '1', 0, NULL, 894, '2020-01-01 00:00:00');
INSERT INTO `schedule_job_log` VALUES (122, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 61, '2020-01-02 00:00:00');
INSERT INTO `schedule_job_log` VALUES (123, 2, 'testTask', '1', 0, NULL, 37, '2020-01-03 00:00:00');
INSERT INTO `schedule_job_log` VALUES (124, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 41, '2020-01-04 00:00:00');
INSERT INTO `schedule_job_log` VALUES (125, 2, 'testTask', '1', 1, 'java.lang.reflect.InvocationTargetException', 56, '2020-01-05 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sys_captcha
-- ----------------------------
DROP TABLE IF EXISTS `sys_captcha`;
CREATE TABLE `sys_captcha` (
  `uuid` char(36) NOT NULL COMMENT 'uuid',
  `code` varchar(6) NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统验证码';

-- ----------------------------
-- Records of sys_captcha
-- ----------------------------
BEGIN;
INSERT INTO `sys_captcha` VALUES ('002554f8-0b7b-4ba1-81f5-8bd27af110a1', '2147', '2019-10-02 16:28:20');
INSERT INTO `sys_captcha` VALUES ('00f920c5-1fc8-4f8c-8f10-c18b91fdbda8', '1637', '2019-10-13 12:10:04');
INSERT INTO `sys_captcha` VALUES ('018b1fb2-3b29-4fde-89c2-44e7473243ba', '5188', '2019-12-22 16:40:07');
INSERT INTO `sys_captcha` VALUES ('01c22b8a-838b-4020-8d24-343c22ad2a68', '6813', '2019-08-17 14:41:51');
INSERT INTO `sys_captcha` VALUES ('03a9fee2-64e0-4719-8e7a-8c9573f37515', '88ggy', '2019-08-15 08:55:40');
INSERT INTO `sys_captcha` VALUES ('03b34fb3-b2e6-4bf7-8192-1f3302c57a16', '7761', '2019-10-02 16:29:46');
INSERT INTO `sys_captcha` VALUES ('04383c14-4e21-2b02-f0c2-010f70417580', '4469', '2019-10-15 23:55:51');
INSERT INTO `sys_captcha` VALUES ('044a4aed-79ff-48a4-8f8c-7b6bf0b1da70', '4cpeg', '2019-08-16 00:44:25');
INSERT INTO `sys_captcha` VALUES ('04fb92d0-0055-4dd4-8582-1adeb16e082f', '23xdw', '2019-08-15 00:29:19');
INSERT INTO `sys_captcha` VALUES ('073578c4-e602-4353-8e95-fb40fcae1f4d', '9855', '2019-11-18 19:08:24');
INSERT INTO `sys_captcha` VALUES ('09cacf04-ef41-43b4-89ce-7b48eb3d98a4', '1893', '2019-11-24 16:27:06');
INSERT INTO `sys_captcha` VALUES ('0ce1f6b1-f9f4-4dd8-8225-6aa8d1400a06', '8048', '2019-10-11 06:23:47');
INSERT INTO `sys_captcha` VALUES ('0cfeccaa-3082-4c49-8b43-8ae9a7484728', 'm5b2x', '2019-08-05 09:38:45');
INSERT INTO `sys_captcha` VALUES ('0d250618-736d-4bf0-88f4-0e8cc3f1cbe7', '2186', '2019-10-02 23:18:17');
INSERT INTO `sys_captcha` VALUES ('10d22ead-c9c8-4faf-82fd-6308212e833c', '2832', '2019-10-18 16:05:04');
INSERT INTO `sys_captcha` VALUES ('126c0f74-884d-4ec8-829b-80b74fcf348e', '1808', '2019-10-21 06:20:23');
INSERT INTO `sys_captcha` VALUES ('1424feda-2621-421a-8d1f-af5e035fc989', '7456', '2019-10-10 09:46:18');
INSERT INTO `sys_captcha` VALUES ('1499abce-3f30-4edc-8ac0-2867da05289d', 'yefm7', '2019-08-16 00:37:17');
INSERT INTO `sys_captcha` VALUES ('149a0474-a770-4d1e-87a8-eb11f7331a92', '6347', '2019-12-05 01:01:10');
INSERT INTO `sys_captcha` VALUES ('160b00d1-edb7-451b-8ad3-8ffca3027a96', '29484', '2019-08-16 12:53:14');
INSERT INTO `sys_captcha` VALUES ('1687c1ee-48e8-452d-858e-29cfce80302a', '0648', '2019-10-13 12:31:23');
INSERT INTO `sys_captcha` VALUES ('17dc5220-8644-440e-818e-ab03aebb6d59', 'nfn4x', '2019-08-16 00:45:19');
INSERT INTO `sys_captcha` VALUES ('192fb925-6dd0-4715-89f8-45c5ae16e758', '4617', '2019-08-25 14:44:42');
INSERT INTO `sys_captcha` VALUES ('1a87ef1b-9582-46e6-8f3d-e27b3ef26195', '7852', '2019-10-13 12:10:13');
INSERT INTO `sys_captcha` VALUES ('1b424755-1011-4513-8708-6c50aa2ba95f', '2044', '2019-10-03 01:47:08');
INSERT INTO `sys_captcha` VALUES ('1b4feb6f-9e35-4372-8af3-2aa51e955f62', 'np626', '2019-08-06 17:35:54');
INSERT INTO `sys_captcha` VALUES ('1c6e637c-e0a2-4fba-8aa6-5cb2973e7681', '6164', '2019-09-01 10:31:51');
INSERT INTO `sys_captcha` VALUES ('1caddb22-ec54-481d-8cdb-60de1f5c22fd', '2003', '2019-11-09 18:16:39');
INSERT INTO `sys_captcha` VALUES ('1d2a1ae2-8b08-41ae-8484-d75f0c71c416', '9941', '2019-10-25 06:07:54');
INSERT INTO `sys_captcha` VALUES ('1d33431c-c533-4a02-8c6b-b95f3995c496', '6115', '2019-10-07 09:04:12');
INSERT INTO `sys_captcha` VALUES ('1d5a4c76-2070-4eb5-813b-a8b636c5261c', '40910', '2019-08-16 13:13:43');
INSERT INTO `sys_captcha` VALUES ('1dd4dce9-e444-1051-6227-f88549507ba2', '7807', '2019-10-15 23:55:52');
INSERT INTO `sys_captcha` VALUES ('1e9f5c63-b685-422e-81b0-ce139377c491', '8541', '2019-10-11 06:23:22');
INSERT INTO `sys_captcha` VALUES ('1f794c21-877c-51ac-4d90-74487ba21a15', '9221', '2019-10-15 23:57:25');
INSERT INTO `sys_captcha` VALUES ('2007791a-6b3c-4203-8fda-d86c43163189', '0548', '2019-11-19 10:44:35');
INSERT INTO `sys_captcha` VALUES ('2123d994-e996-4924-8057-485c3f93fd7a', '1684', '2019-12-28 17:22:30');
INSERT INTO `sys_captcha` VALUES ('22c96af2-0ae7-4b5e-8679-1426e9e4351a', '8840', '2019-11-17 16:32:39');
INSERT INTO `sys_captcha` VALUES ('25f77fcb-8a16-4349-867f-47434b81a33b', '8151', '2019-10-31 07:34:11');
INSERT INTO `sys_captcha` VALUES ('26106da3-a888-e9d4-377a-6d0c99b55cba', '1117', '2019-10-15 23:56:42');
INSERT INTO `sys_captcha` VALUES ('282f82e8-5b05-4dfc-8cf9-d97ff793aaad', '5660', '2019-10-03 18:12:24');
INSERT INTO `sys_captcha` VALUES ('28ccebd3-6b3b-46d1-8c00-c1bf9dd4cb73', 'nnnpf', '2019-08-16 00:37:27');
INSERT INTO `sys_captcha` VALUES ('29327a80-3cd7-4b2d-82e9-8efa415b6fa3', '4915', '2019-10-11 06:21:33');
INSERT INTO `sys_captcha` VALUES ('2a91a070-9117-4ba7-8fbe-d1daeb35eca2', '6105', '2019-10-21 02:42:24');
INSERT INTO `sys_captcha` VALUES ('2b155e32-1558-4e53-8edc-a90d485d34bb', '1885', '2019-10-11 06:25:26');
INSERT INTO `sys_captcha` VALUES ('2ba111f4-4373-dc1f-6de0-edbe0706e4e5', '3388', '2019-10-13 22:10:16');
INSERT INTO `sys_captcha` VALUES ('2ca6a516-15bf-4e7d-855d-9e5027276844', '5130', '2019-10-04 18:19:37');
INSERT INTO `sys_captcha` VALUES ('2dd0b19c-b00a-4e63-83c5-0c91ebb3b442', '4637', '2019-10-03 18:12:05');
INSERT INTO `sys_captcha` VALUES ('2de1dc0a-67c4-40a3-8f95-44eb029f3823', 'yp8g6', '2019-08-15 16:51:44');
INSERT INTO `sys_captcha` VALUES ('2e0a7738-c51a-437d-8323-6cbf9b29d674', '6pnbx', '2019-08-16 00:36:23');
INSERT INTO `sys_captcha` VALUES ('302c0c91-a3d9-6f89-58b4-a67384450fd7', '1859', '2019-10-15 23:57:22');
INSERT INTO `sys_captcha` VALUES ('304359d5-8bbb-6da7-290e-6fdb1a0dc663', '7376', '2019-10-15 23:55:02');
INSERT INTO `sys_captcha` VALUES ('312ef355-fa62-411d-84c3-9b2521d256fd', '4692', '2019-12-19 17:17:20');
INSERT INTO `sys_captcha` VALUES ('31773d9b-f89f-4d69-8613-54469b99d5f6', 'a4mwe', '2019-08-13 23:06:28');
INSERT INTO `sys_captcha` VALUES ('319fb45e-7811-467f-8136-3bb9c231678d', '8848', '2019-10-13 12:30:03');
INSERT INTO `sys_captcha` VALUES ('324c1654-cf34-4028-8ed6-8a336f9a85df', '0388', '2019-10-11 06:26:25');
INSERT INTO `sys_captcha` VALUES ('3373ad58-12e9-4894-84dc-0a0bbc926df2', '7997', '2019-09-28 13:37:26');
INSERT INTO `sys_captcha` VALUES ('3417eeac-e97a-4b7a-8bd0-8275eac69dd7', 'cbm75', '2019-08-06 16:23:48');
INSERT INTO `sys_captcha` VALUES ('35a19e81-7bc6-4af2-8198-e261d8664982', '0042', '2019-10-11 06:24:16');
INSERT INTO `sys_captcha` VALUES ('36c6a1aa-a93f-44f4-8bb5-e1d15cb1896f', '0827', '2019-12-27 17:52:35');
INSERT INTO `sys_captcha` VALUES ('36cb0188-8da0-414b-8b16-801e2555d3e1', '2376', '2019-10-03 01:47:28');
INSERT INTO `sys_captcha` VALUES ('37199846-2d49-5b5c-19ac-257c795b85af', '8761', '2019-10-13 17:36:43');
INSERT INTO `sys_captcha` VALUES ('3a75d0dc-5b70-48cd-8c80-667cd18a90a0', '4728', '2019-10-18 16:05:33');
INSERT INTO `sys_captcha` VALUES ('3a9d016c-2c05-4be8-8d40-7d171c469442', '7670', '2019-10-05 10:25:36');
INSERT INTO `sys_captcha` VALUES ('3b408cf9-c252-46ac-8239-e52264688610', '4n5e6', '2019-08-16 00:39:50');
INSERT INTO `sys_captcha` VALUES ('3bc86126-736f-4117-87da-cb98b327fb6d', '0326', '2019-10-13 19:32:00');
INSERT INTO `sys_captcha` VALUES ('3d645e3c-8d57-49f4-869e-adf64f54bd94', '3019', '2019-12-30 07:54:05');
INSERT INTO `sys_captcha` VALUES ('3ddd0f7c-3307-6f57-7cbc-359e54e4fe5c', '0043', '2019-10-14 22:30:05');
INSERT INTO `sys_captcha` VALUES ('3e7fe461-dadd-4549-264f-29a39c4ef28f', '6783', '2019-10-13 21:44:57');
INSERT INTO `sys_captcha` VALUES ('3eb41579-5a48-473e-8d92-45257d3e40b4', '2578', '2019-10-31 22:28:33');
INSERT INTO `sys_captcha` VALUES ('3f1e8242-f684-4d7d-8e52-1cb780456842', '6595', '2019-09-04 15:03:49');
INSERT INTO `sys_captcha` VALUES ('4235dc58-1beb-48a6-8517-9f28793a761d', '7761', '2019-11-21 02:47:10');
INSERT INTO `sys_captcha` VALUES ('426226a9-5420-457f-83bd-ab569fae150e', '6354', '2019-08-30 22:59:57');
INSERT INTO `sys_captcha` VALUES ('436826da-7417-4630-825b-e99d1877a9a3', '8120', '2019-10-14 22:29:46');
INSERT INTO `sys_captcha` VALUES ('44f49198-276d-4da9-8553-837b461bd049', '7061', '2019-10-13 12:14:05');
INSERT INTO `sys_captcha` VALUES ('467e8b35-0bed-45df-8b1a-935f06fd8916', '4183', '2019-10-11 06:25:03');
INSERT INTO `sys_captcha` VALUES ('4712125e-4143-46ea-8e95-5bc055dbb34b', '2475', '2019-08-29 22:38:38');
INSERT INTO `sys_captcha` VALUES ('477cd05a-ca81-4ced-8075-eafbb76dbd0e', '8314', '2019-10-11 06:25:45');
INSERT INTO `sys_captcha` VALUES ('47fced89-2780-40c2-8211-0abe1639b505', '2577', '2020-01-02 07:12:04');
INSERT INTO `sys_captcha` VALUES ('48a12ba8-cadd-4662-8345-7e4a1f9d9035', 'ngm27', '2019-08-15 16:38:08');
INSERT INTO `sys_captcha` VALUES ('491aa753-e2c3-47ae-8752-b22e43f5735c', '5598', '2019-12-27 07:46:24');
INSERT INTO `sys_captcha` VALUES ('4a202825-2da9-4625-8f57-532ea8f0ca16', 'e3ey7', '2019-08-16 00:39:48');
INSERT INTO `sys_captcha` VALUES ('4c335bc2-c2bc-4031-87ab-af5407719400', '98488', '2019-08-16 00:51:03');
INSERT INTO `sys_captcha` VALUES ('4cb47923-d3d0-4bd6-8e18-a201403bcf29', 'nnee3', '2019-08-06 16:22:42');
INSERT INTO `sys_captcha` VALUES ('4d5537ba-a5fa-365e-80ad-b46881a619ca', '0797', '2019-10-13 16:42:21');
INSERT INTO `sys_captcha` VALUES ('4e133789-6844-4f11-8a33-977109e581db', '1467', '2019-10-04 00:43:17');
INSERT INTO `sys_captcha` VALUES ('4e1eb8cb-887a-4a31-8e13-a7ccdd62c92b', '3neng', '2019-08-16 00:36:21');
INSERT INTO `sys_captcha` VALUES ('4f3c340f-434b-c012-282b-6777c15b166a', '7586', '2019-10-13 19:30:37');
INSERT INTO `sys_captcha` VALUES ('512979d9-d170-43a2-8b77-65b3a27fd63c', 'd848c', '2019-08-16 00:37:25');
INSERT INTO `sys_captcha` VALUES ('522f1b45-65d4-4bbb-890a-ab6e56a3a5bd', '7844', '2019-10-11 06:25:14');
INSERT INTO `sys_captcha` VALUES ('531dfe78-4029-46e1-870c-92f58499f314', '0377', '2019-12-15 16:12:29');
INSERT INTO `sys_captcha` VALUES ('53d53e64-503f-45a5-890e-12f413b5b909', '8110', '2019-08-25 14:44:42');
INSERT INTO `sys_captcha` VALUES ('53f5774e-989d-0138-9988-5d3d48fd75e5', '5932', '2019-10-13 19:32:05');
INSERT INTO `sys_captcha` VALUES ('53fc88ca-3ac8-4227-85d8-22f48d3f90e3', '7730', '2019-10-04 01:28:37');
INSERT INTO `sys_captcha` VALUES ('56ab02ad-4601-2f68-3b2a-19ee206a9232', '9649', '2019-10-13 22:09:36');
INSERT INTO `sys_captcha` VALUES ('57ceeb59-183c-4aee-8897-e85615634d53', '5081', '2019-12-29 09:37:27');
INSERT INTO `sys_captcha` VALUES ('5bb67d9b-d997-40b0-8a68-2bd52082e262', '1530', '2019-10-03 01:12:32');
INSERT INTO `sys_captcha` VALUES ('5d6acb09-19e4-4115-832e-6c0894aaa075', '6054', '2019-09-24 19:54:50');
INSERT INTO `sys_captcha` VALUES ('5f3488ba-3c22-4fb8-810c-ab8eadcf7621', 'c3ney', '2019-08-15 16:45:35');
INSERT INTO `sys_captcha` VALUES ('612b1e15-7567-495a-88d6-e9c666cd7c0c', '9352', '2019-08-25 00:47:40');
INSERT INTO `sys_captcha` VALUES ('61de4e0d-f57f-4f4a-8d61-128fefc6f894', '4239', '2019-10-16 00:17:12');
INSERT INTO `sys_captcha` VALUES ('61ea6f55-9dc7-46ca-8347-2981aeb8fce8', '7462', '2019-10-11 06:25:13');
INSERT INTO `sys_captcha` VALUES ('62d67a50-8511-47c2-8ed1-b157e0b79b6c', '7491', '2019-12-11 22:33:50');
INSERT INTO `sys_captcha` VALUES ('6338c7d3-1ce2-4164-8d88-2929ad28b0d2', '4cm4a', '2019-08-16 00:25:59');
INSERT INTO `sys_captcha` VALUES ('646be804-15ea-f786-0328-62811169c5cc', '8846', '2019-10-19 23:01:20');
INSERT INTO `sys_captcha` VALUES ('64e58584-87f4-eae3-cb42-d2439a321090', '2804', '2019-10-13 19:32:50');
INSERT INTO `sys_captcha` VALUES ('64eec138-31b6-4701-8b67-cafd81c44baa', '9571', '2019-08-30 23:01:04');
INSERT INTO `sys_captcha` VALUES ('655ef3dc-99a7-4a77-8f6a-241e8fce5465', '1742', '2019-12-01 08:44:42');
INSERT INTO `sys_captcha` VALUES ('66ae05e0-e372-4395-8d45-d77489d52051', '6500', '2019-11-09 21:05:08');
INSERT INTO `sys_captcha` VALUES ('66cc61d3-fe80-42b2-8146-9210eba53878', '1192', '2019-10-15 20:53:59');
INSERT INTO `sys_captcha` VALUES ('671abd2a-167d-4b41-8f6f-ddd5f6754965', '2269', '2019-10-13 12:13:18');
INSERT INTO `sys_captcha` VALUES ('671d122c-025c-4f74-864a-409e02c883d5', '1675', '2019-11-09 18:16:39');
INSERT INTO `sys_captcha` VALUES ('67381ad2-6d87-4bf1-8777-708c69c1f4f9', 'bnmna', '2019-08-14 00:30:09');
INSERT INTO `sys_captcha` VALUES ('6787725f-8d1e-42dd-8318-ba432ce9eb95', '8949', '2019-10-11 15:32:14');
INSERT INTO `sys_captcha` VALUES ('6a779d6f-eff7-48bf-8bff-d92faa16a495', '9658', '2019-12-29 08:51:44');
INSERT INTO `sys_captcha` VALUES ('6e92e828-1f01-4ea5-888d-02ecb677d182', '1901', '2019-08-24 00:34:34');
INSERT INTO `sys_captcha` VALUES ('6fff882b-a5a0-41cb-8984-515da7f7a9dc', '7534', '2019-10-24 17:01:28');
INSERT INTO `sys_captcha` VALUES ('707e59b9-9481-4762-811a-aaa8d0e73616', '1127', '2019-10-05 13:06:45');
INSERT INTO `sys_captcha` VALUES ('710c7cb4-512c-4f5d-82ad-a32d8950fd28', 'y8ae7', '2019-08-16 00:36:12');
INSERT INTO `sys_captcha` VALUES ('7145f328-1d0f-42aa-81bb-55d873132daa', '5089', '2019-10-10 16:24:50');
INSERT INTO `sys_captcha` VALUES ('71512b10-6e61-47a0-8807-89e1a4c29c18', '4669', '2019-12-17 07:29:48');
INSERT INTO `sys_captcha` VALUES ('72291f09-5d0d-cad3-d326-e6af2c93a1dc', '6050', '2019-10-15 23:57:25');
INSERT INTO `sys_captcha` VALUES ('73bea70c-2888-46b0-8c90-eaac151530fa', '9777', '2019-10-13 12:10:15');
INSERT INTO `sys_captcha` VALUES ('741cebec-656b-441c-80ec-67c9e5760fe7', '8837', '2019-10-13 12:12:59');
INSERT INTO `sys_captcha` VALUES ('7431a111-457e-402b-89a2-d174c2768a50', '0790', '2019-10-11 06:23:39');
INSERT INTO `sys_captcha` VALUES ('75483921-fc8c-4480-8640-7b0033c747fe', '1119', '2019-10-13 12:10:14');
INSERT INTO `sys_captcha` VALUES ('761abdae-3e80-4322-86bd-a19895610c65', '9087', '2019-09-24 15:31:03');
INSERT INTO `sys_captcha` VALUES ('76ba89ed-a355-0666-d6b9-ff8c45b685a6', '7011', '2019-10-15 23:55:53');
INSERT INTO `sys_captcha` VALUES ('77430cc8-16b4-58b1-477b-23a0badd91cb', '0058', '2019-10-13 19:32:56');
INSERT INTO `sys_captcha` VALUES ('7c067136-7d85-4fa6-8b36-3a727dd07a45', '6680', '2019-10-04 18:34:06');
INSERT INTO `sys_captcha` VALUES ('7cb8b0f6-3d53-4f77-8ca7-8c7106048c6e', '1251', '2019-10-13 11:18:07');
INSERT INTO `sys_captcha` VALUES ('7d8a9e6a-d6dd-4184-8eba-1e1d30eae414', '7368', '2019-10-11 06:24:18');
INSERT INTO `sys_captcha` VALUES ('7ee24e0a-6bb1-4bd4-86df-c0e3136ac353', '7aa22', '2019-08-06 14:53:02');
INSERT INTO `sys_captcha` VALUES ('7f54289a-78d7-85f9-6cde-f26d8285ea77', '9684', '2019-10-13 21:12:43');
INSERT INTO `sys_captcha` VALUES ('7fd1a556-3a3c-4f4b-859a-fcf86846de90', '4904', '2019-10-05 10:54:52');
INSERT INTO `sys_captcha` VALUES ('80239433-b7c5-405a-8d6a-0c4ee62dd017', '5998', '2019-12-01 08:44:47');
INSERT INTO `sys_captcha` VALUES ('80d38259-de6a-48cd-8fc6-cfc2f8d5e590', '9657', '2019-11-26 03:21:14');
INSERT INTO `sys_captcha` VALUES ('8435e654-2eba-5d3b-18d7-e7f505f822c2', '5486', '2019-10-14 15:34:48');
INSERT INTO `sys_captcha` VALUES ('84850984-813d-4b72-8363-c112c51b7d4e', '0882', '2019-08-16 00:53:06');
INSERT INTO `sys_captcha` VALUES ('850fcecb-0792-280a-c7a0-d89b01ac7342', '4834', '2019-10-14 22:31:19');
INSERT INTO `sys_captcha` VALUES ('85587540-f27f-4e19-8aa1-9a7875112e1b', 'g76nf', '2019-08-07 14:36:44');
INSERT INTO `sys_captcha` VALUES ('856ab7ee-35ca-420a-80a8-47ca9a9e0133', '238m2', '2019-08-16 09:24:15');
INSERT INTO `sys_captcha` VALUES ('8682893b-2de6-4e0e-82d7-e9bc7ff2c92e', '7491', '2019-08-16 00:53:07');
INSERT INTO `sys_captcha` VALUES ('868fb5ef-9e20-4504-8c30-79c5f09cdb4b', '8536', '2019-12-07 16:35:16');
INSERT INTO `sys_captcha` VALUES ('87dd1ec0-6fbd-44b5-83bd-90d33b876644', '9597', '2019-08-17 14:54:09');
INSERT INTO `sys_captcha` VALUES ('899c0854-1bb6-8cf7-a62a-6842ae3ae4e5', '3877', '2019-10-13 19:32:50');
INSERT INTO `sys_captcha` VALUES ('8af639c0-3378-4fff-804d-0e1bcf7f38cc', '4169', '2019-08-16 00:53:06');
INSERT INTO `sys_captcha` VALUES ('8b61e8e5-1b0a-4705-807e-2e40cf6ce0a8', '4586', '2019-11-13 16:40:48');
INSERT INTO `sys_captcha` VALUES ('8cd14190-04af-4241-8a78-3195bc5255a9', '40290', '2019-08-16 09:24:00');
INSERT INTO `sys_captcha` VALUES ('8dc85ad7-6dcd-4182-86ef-fa2c52ffa74a', '4677', '2019-10-11 06:26:07');
INSERT INTO `sys_captcha` VALUES ('8f522ce4-0994-4b9a-8047-45d60fe19de6', '42929', '2019-08-16 13:14:30');
INSERT INTO `sys_captcha` VALUES ('90abe25d-9b3c-408f-8709-35129e5840bd', '7569', '2019-10-04 02:25:40');
INSERT INTO `sys_captcha` VALUES ('90fd8a40-b54d-40c3-8d64-dc4b1851ca6f', '8518', '2019-10-18 14:40:10');
INSERT INTO `sys_captcha` VALUES ('91abbef4-f5f4-4f53-8a54-3d25c8f7036f', '2x82p', '2019-08-15 08:55:39');
INSERT INTO `sys_captcha` VALUES ('91f5b88f-d3c7-4eea-80f7-89c6fd9ec6e5', '9681', '2020-01-03 07:39:19');
INSERT INTO `sys_captcha` VALUES ('94ee42ac-ce29-41df-8c03-bc724ee35878', '0022', '2019-10-05 11:04:26');
INSERT INTO `sys_captcha` VALUES ('951d1d1c-795f-49f5-898e-0a52f9be7a0d', '7408', '2019-10-03 18:12:26');
INSERT INTO `sys_captcha` VALUES ('965b7e6d-c1e8-4634-8352-f28aa34e51d6', '3586', '2019-10-05 06:17:47');
INSERT INTO `sys_captcha` VALUES ('9724dbd9-ee61-43e8-8662-ea40f5ff6d93', '6651', '2019-12-27 19:22:06');
INSERT INTO `sys_captcha` VALUES ('9766e06b-77b8-5779-b60e-672292f46020', '3106', '2019-10-13 19:29:14');
INSERT INTO `sys_captcha` VALUES ('97fae933-57fa-4cd9-8107-21c8baa271ca', '2108', '2019-10-21 03:56:32');
INSERT INTO `sys_captcha` VALUES ('98025417-daee-443a-853c-08a6fc00c266', '0317', '2019-10-25 06:08:32');
INSERT INTO `sys_captcha` VALUES ('981a8da0-c93a-46e3-8252-627b2f41f445', '5128', '2019-10-11 06:24:39');
INSERT INTO `sys_captcha` VALUES ('9a23c72a-37fd-4d40-8c2a-76d56f555ae2', 'nmwyn', '2019-08-06 16:22:16');
INSERT INTO `sys_captcha` VALUES ('9af4ebca-92f5-435d-81f3-766649bce1b0', '7394', '2019-10-13 12:13:25');
INSERT INTO `sys_captcha` VALUES ('9b94b7d2-31b3-4c01-8b2b-0da00f0a6381', '9589', '2019-10-02 23:42:01');
INSERT INTO `sys_captcha` VALUES ('9c098190-3ec2-4771-87cc-c061c819a030', '5299', '2019-10-14 22:29:23');
INSERT INTO `sys_captcha` VALUES ('9c150c31-5db2-4e35-83cb-8d95b0565749', 'n66ac', '2019-08-06 17:46:23');
INSERT INTO `sys_captcha` VALUES ('9e3355cc-dfe7-4cc9-8e2b-20d318fb7e33', '3638', '2019-12-28 17:22:27');
INSERT INTO `sys_captcha` VALUES ('9e3d6cc6-e195-4645-8977-9040d84bc1f8', '0154', '2019-08-25 00:23:53');
INSERT INTO `sys_captcha` VALUES ('9e998f13-b49f-4d28-8d02-17f77bd13b7c', '7327', '2019-10-04 00:42:26');
INSERT INTO `sys_captcha` VALUES ('9fa158b1-5164-4853-8a8f-c5f9a16dbf93', '6419', '2019-10-11 06:24:50');
INSERT INTO `sys_captcha` VALUES ('a0259f04-279f-4923-8ace-3328bd0568d2', 'nc3wf', '2019-08-16 00:39:44');
INSERT INTO `sys_captcha` VALUES ('a08f444e-78a4-40fa-8b40-ebebc5639d7e', '3501', '2019-08-16 00:53:02');
INSERT INTO `sys_captcha` VALUES ('a09d5aa0-9b91-48b5-80ba-cd6020262478', '3965', '2019-10-11 06:24:31');
INSERT INTO `sys_captcha` VALUES ('a19cea86-97d8-43d0-845e-daf272e8bb66', '5448', '2019-12-28 03:18:31');
INSERT INTO `sys_captcha` VALUES ('a1c60007-abc5-4c51-8edd-4492efa570c7', '4654', '2019-10-11 06:25:49');
INSERT INTO `sys_captcha` VALUES ('a223bb81-947a-45db-829e-19724b0b047f', '5602', '2019-10-28 17:46:14');
INSERT INTO `sys_captcha` VALUES ('a366f33e-a282-41fb-8f2e-66646cac5df7', '7498', '2019-10-20 17:07:48');
INSERT INTO `sys_captcha` VALUES ('a3fbf2a6-528a-4228-8a42-4ad395459aa1', '4789', '2019-08-16 00:53:03');
INSERT INTO `sys_captcha` VALUES ('a4ccbcc3-a9e5-844d-f4d4-ea642d3a81ef', '8259', '2019-10-14 15:34:51');
INSERT INTO `sys_captcha` VALUES ('a5ab73a0-2ac6-4382-8946-2f80a366819f', '2183', '2019-08-24 00:43:51');
INSERT INTO `sys_captcha` VALUES ('a5c75183-9d5d-49a3-83ea-91b9e7757d33', '0836', '2019-10-07 19:46:29');
INSERT INTO `sys_captcha` VALUES ('a61d27d2-6cd6-4558-823d-8b4b43898f88', '8369', '2019-10-13 13:23:36');
INSERT INTO `sys_captcha` VALUES ('a6b69dae-da07-42a2-8209-854f4b178707', '7119', '2019-10-06 20:12:48');
INSERT INTO `sys_captcha` VALUES ('a7eed93c-1e62-45a9-819a-babceb49e4ae', '0621', '2019-11-20 19:54:10');
INSERT INTO `sys_captcha` VALUES ('a819269e-e39b-43bc-8aa7-f45e9cc2cefb', 'yn63f', '2019-08-15 08:54:51');
INSERT INTO `sys_captcha` VALUES ('a9994fb0-f160-4043-8d51-04b4362f76e7', '9304', '2019-09-07 09:55:03');
INSERT INTO `sys_captcha` VALUES ('aa21efcf-684b-4fa8-8290-8cf2e65ed7c7', '4293', '2019-10-28 23:37:28');
INSERT INTO `sys_captcha` VALUES ('aab2235d-9c37-4cc4-87eb-c8d909c3eb3b', '6420', '2019-10-04 02:24:44');
INSERT INTO `sys_captcha` VALUES ('abb2a515-5e18-8b30-68d1-66b59518fa01', '0172', '2019-10-13 19:15:53');
INSERT INTO `sys_captcha` VALUES ('acf23575-9cfc-491c-84d5-0e1e78453f6d', '8489', '2019-08-30 10:03:37');
INSERT INTO `sys_captcha` VALUES ('ae0a067a-008e-4cf7-8383-daa53b85528f', '6449', '2019-08-16 00:53:04');
INSERT INTO `sys_captcha` VALUES ('af8e3dc2-948b-43fb-8da6-0ad1b2d6c6ed', '5089', '2019-08-16 00:52:55');
INSERT INTO `sys_captcha` VALUES ('b0ca3713-cbe3-696b-6af7-4ba5d266e19f', '4304', '2019-10-13 17:28:56');
INSERT INTO `sys_captcha` VALUES ('b1655a57-be26-490d-8f16-fc436f4150aa', '825d2', '2019-08-15 16:42:27');
INSERT INTO `sys_captcha` VALUES ('b3dc71e7-5885-44f7-8aa6-f72baa5ec57f', '0443', '2019-10-11 06:23:41');
INSERT INTO `sys_captcha` VALUES ('b6d2ded2-813b-4d99-8234-ea2c8cd65432', '3036', '2019-11-09 19:20:27');
INSERT INTO `sys_captcha` VALUES ('b7c89dff-a964-4b6a-8b49-f94ec21f4735', 'bgp3e', '2019-08-16 00:45:05');
INSERT INTO `sys_captcha` VALUES ('b8340351-b3d4-784e-b622-ef9ade4fb3cb', '3886', '2019-10-13 17:20:02');
INSERT INTO `sys_captcha` VALUES ('b8b3d18b-208e-423a-8ba5-8a6c33860445', '8010', '2019-10-18 14:35:31');
INSERT INTO `sys_captcha` VALUES ('b93d5173-ebf9-4468-8a8d-3a553b9d5baa', 'npnf8', '2019-08-15 16:40:47');
INSERT INTO `sys_captcha` VALUES ('ba129f84-9624-400d-82e2-b16247022a31', '6014', '2019-12-31 18:26:09');
INSERT INTO `sys_captcha` VALUES ('bab27f64-9cc6-4aa2-897b-846a572eba9d', '4454', '2019-10-20 22:24:57');
INSERT INTO `sys_captcha` VALUES ('bb54bf90-0909-41f7-8fad-e7972c3c773f', '8817', '2019-10-13 12:10:35');
INSERT INTO `sys_captcha` VALUES ('bc11ddec-c66b-4303-8ab2-ea3146a73344', '9421', '2019-08-31 21:58:27');
INSERT INTO `sys_captcha` VALUES ('bd7dd98f-90d0-4498-82b9-37d49cf7ba87', '9536', '2019-10-13 12:13:25');
INSERT INTO `sys_captcha` VALUES ('bd81f00c-24d5-44fa-84ff-ada5a03baa69', '8183', '2019-10-13 12:28:53');
INSERT INTO `sys_captcha` VALUES ('bdf54f32-6b65-982e-2723-a3f079559457', '2066', '2019-10-13 16:12:23');
INSERT INTO `sys_captcha` VALUES ('bf2509f0-a96a-a6ed-0afd-ea3ad6c6611c', '5524', '2019-10-13 17:26:35');
INSERT INTO `sys_captcha` VALUES ('c1bf50c6-7500-4ea6-8c83-6be6681d05ac', '1183', '2019-10-04 21:00:11');
INSERT INTO `sys_captcha` VALUES ('c344c754-ded5-4cad-898d-a1619bbef850', '73865', '2019-08-16 20:14:38');
INSERT INTO `sys_captcha` VALUES ('c3ec65ae-0bd0-4e09-8e31-b71348561d8b', '5742', '2019-11-02 22:04:19');
INSERT INTO `sys_captcha` VALUES ('c42e0cec-54ba-4f9e-8d65-2508583061eb', '5293', '2019-10-11 06:24:46');
INSERT INTO `sys_captcha` VALUES ('c8cd7fe8-23a6-4d13-8b0d-c6b6c3fe9c8e', '1095', '2019-08-25 16:28:15');
INSERT INTO `sys_captcha` VALUES ('c90cd69a-c71f-4e21-80b1-3f4ef7646021', '7096', '2019-10-24 16:28:57');
INSERT INTO `sys_captcha` VALUES ('c9a3d260-6bfc-4289-8a83-8cb4d35fc458', '0885', '2019-10-11 07:17:04');
INSERT INTO `sys_captcha` VALUES ('ce881d8a-c87a-485d-87c3-ae269b09f646', '1954', '2019-11-21 10:03:07');
INSERT INTO `sys_captcha` VALUES ('d16d99f4-0681-4178-8972-21660644d148', '8219', '2019-10-02 23:42:01');
INSERT INTO `sys_captcha` VALUES ('d5038524-63f0-41c8-815e-0f382050f5c2', '6797', '2019-10-25 14:17:15');
INSERT INTO `sys_captcha` VALUES ('d6039b04-f9a1-43e1-8480-420a8a6310ac', '4404', '2019-10-12 00:18:00');
INSERT INTO `sys_captcha` VALUES ('d86b4b97-1042-4dda-8076-150a2b215c3f', '7165', '2019-08-16 00:53:07');
INSERT INTO `sys_captcha` VALUES ('d8889081-e6c9-48f1-8a4a-0737a476a5b5', '9670', '2019-10-04 14:49:30');
INSERT INTO `sys_captcha` VALUES ('da0b2bdd-8310-4406-8faf-cf6d9048ddf8', '4890', '2019-10-05 10:46:58');
INSERT INTO `sys_captcha` VALUES ('db3a5b5b-a374-4c02-8a13-8f775b30dfda', 'mx4cf', '2019-08-16 00:37:24');
INSERT INTO `sys_captcha` VALUES ('db98298b-faa7-b87c-d3b0-a638e0ee902e', '1090', '2019-10-13 19:32:56');
INSERT INTO `sys_captcha` VALUES ('ddf861ba-ceb2-435a-86c5-ee3c07fd5c41', '9526', '2019-10-03 15:42:20');
INSERT INTO `sys_captcha` VALUES ('e10e5b88-be7e-4d8e-896f-877bb557bce3', '9505', '2019-10-13 12:29:02');
INSERT INTO `sys_captcha` VALUES ('e25ef3d9-9e07-45ba-8179-c95cb4039538', '4001', '2019-08-16 00:53:08');
INSERT INTO `sys_captcha` VALUES ('e2e92ede-3daa-4806-8d06-b793ec9d63b2', '1970', '2019-08-16 00:53:08');
INSERT INTO `sys_captcha` VALUES ('e3302de9-6c04-da38-49d8-740205df1054', '8987', '2019-10-15 23:55:48');
INSERT INTO `sys_captcha` VALUES ('e3dc20b2-bbc2-437d-820e-bb5f730ff20a', '9176', '2019-11-11 22:57:23');
INSERT INTO `sys_captcha` VALUES ('e641b96b-558e-e1e4-df4a-ee1d0bd302cf', '5531', '2019-10-13 16:29:54');
INSERT INTO `sys_captcha` VALUES ('e83f2158-416e-4e48-86b3-c5a00eabb47b', '2344', '2019-08-25 21:43:58');
INSERT INTO `sys_captcha` VALUES ('e8a99ba4-4657-2682-1c86-0648917018fd', '3854', '2019-10-15 23:55:52');
INSERT INTO `sys_captcha` VALUES ('eb312066-25b0-4b83-839a-5faafefbfc8a', 'd4cm3', '2019-08-16 00:36:18');
INSERT INTO `sys_captcha` VALUES ('ecd6ccfc-405d-4712-8edd-51126d7d2739', '3561', '2019-11-13 21:46:50');
INSERT INTO `sys_captcha` VALUES ('ee1d95c1-0700-45da-8811-3d2bd4be2bed', '9188', '2019-10-02 23:41:38');
INSERT INTO `sys_captcha` VALUES ('ee2944ad-6567-482d-83f7-cacb06f23b9f', '5670', '2019-12-07 07:54:13');
INSERT INTO `sys_captcha` VALUES ('eeb79c64-225e-497c-896c-12aec6e15c64', 'wcmae', '2019-08-16 00:27:59');
INSERT INTO `sys_captcha` VALUES ('eefc5ff6-4391-4667-8102-01df71d0b2c3', '7050', '2019-09-13 12:51:59');
INSERT INTO `sys_captcha` VALUES ('ef8b15ec-5e29-462e-8c38-52e44a3525f3', '8508', '2019-10-11 06:25:12');
INSERT INTO `sys_captcha` VALUES ('f012e6c4-5e29-85d6-c4b1-60c82d7ebd06', '9189', '2019-10-13 17:26:56');
INSERT INTO `sys_captcha` VALUES ('f03838cf-eee6-47b4-82f8-e23bb968c81e', 'fdanw', '2019-08-06 17:45:37');
INSERT INTO `sys_captcha` VALUES ('f184087c-74e8-34db-07a5-17a94e6b6b29', '9551', '2019-10-13 17:36:02');
INSERT INTO `sys_captcha` VALUES ('f21f9659-6387-459f-8ffc-585a3bcc7a79', '7765', '2019-08-24 00:42:28');
INSERT INTO `sys_captcha` VALUES ('f459f051-652d-4015-827b-2b59219c4265', '2776', '2019-12-11 14:19:59');
INSERT INTO `sys_captcha` VALUES ('f5392e5d-96ae-4150-8a16-a7fef7c25165', '2015', '2019-10-02 23:41:03');
INSERT INTO `sys_captcha` VALUES ('f57ecce2-0695-489e-8cea-70d4d9fee0fe', '1330', '2019-10-03 01:20:22');
INSERT INTO `sys_captcha` VALUES ('f5804da7-da7e-aaf2-17ed-c4481c18117f', '5620', '2019-10-13 16:11:23');
INSERT INTO `sys_captcha` VALUES ('f8c0b0ff-7669-4b3b-8ec0-8a6466fd54fc', '0927', '2019-10-09 13:34:12');
INSERT INTO `sys_captcha` VALUES ('fad6d8f0-8a37-4d38-8aa6-618058ff3762', '1244', '2019-10-11 07:45:00');
INSERT INTO `sys_captcha` VALUES ('fb062567-94af-13b6-52dc-5f21d6901b3c', '4057', '2019-10-15 23:57:20');
INSERT INTO `sys_captcha` VALUES ('fb3da43e-4e8f-8c8e-180c-33ef0ec9ef86', '3053', '2019-10-13 17:36:41');
INSERT INTO `sys_captcha` VALUES ('fb51e65a-4f76-4152-8e49-2c40c330e6be', '2556', '2019-08-24 00:34:39');
INSERT INTO `sys_captcha` VALUES ('fb566ee6-08ab-2d13-d52c-a7762b8f1e06', '1438', '2019-10-13 19:30:37');
INSERT INTO `sys_captcha` VALUES ('fbbe8a6f-b4cb-8635-8da8-260de0b949dd', '4452', '2019-10-13 19:32:05');
INSERT INTO `sys_captcha` VALUES ('fc9260bb-3694-4931-8a3b-af9c2fcf0f05', '0589', '2019-09-06 05:27:25');
INSERT INTO `sys_captcha` VALUES ('fe9c4c22-217b-40a9-8a55-f44e3032a24e', '1337', '2019-12-15 16:34:46');
INSERT INTO `sys_captcha` VALUES ('fed25379-7034-4918-8583-802b05d077d9', '6301', '2019-10-11 06:27:58');
INSERT INTO `sys_captcha` VALUES ('ff0e30ac-523e-4b67-8a63-4bd02b30471d', '3740', '2019-10-18 16:15:30');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `param_key` varchar(50) DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `param_key` (`param_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"ios-app\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', 0, '云存储配置信息');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1, 'admin', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '[{\"userId\":2,\"username\":\"lalala\",\"password\":\"f32d497b0a69a9f5bb5af06ca464df1f45438bcfa6da6a160d3dd986a8e81386\",\"salt\":\"GxUs81ygKTDNdSTSKRpM\",\"email\":\"1273022039@qq.com\",\"mobile\":\"15538122563\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Aug 6, 2019 5:53:19 PM\"}]', 299, '0:0:0:0:0:0:0:1', '2019-08-06 17:53:20');
INSERT INTO `sys_log` VALUES (2, 'admin', '保存角色', 'io.renren.modules.sys.controller.SysRoleController.save()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,-666666],\"createTime\":\"Aug 6, 2019 5:53:56 PM\"}]', 1231, '0:0:0:0:0:0:0:1', '2019-08-06 17:53:58');
INSERT INTO `sys_log` VALUES (3, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '[{\"userId\":1,\"username\":\"admin\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13500000001\",\"status\":1,\"roleIdList\":[1],\"createUserId\":1}]', 185, '0:0:0:0:0:0:0:1', '2019-08-06 17:54:11');
INSERT INTO `sys_log` VALUES (4, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '[{\"userId\":2,\"username\":\"lalala\",\"salt\":\"GxUs81ygKTDNdSTSKRpM\",\"email\":\"1273022039@qq.com\",\"mobile\":\"15538122563\",\"status\":1,\"roleIdList\":[1],\"createUserId\":1}]', 194, '0:0:0:0:0:0:0:1', '2019-08-06 17:54:16');
INSERT INTO `sys_log` VALUES (5, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":31,\"parentId\":0,\"name\":\"业务管理\",\"type\":0,\"icon\":\"zonghe\",\"orderNum\":2}]', 48, '0:0:0:0:0:0:0:1', '2019-08-13 21:44:29');
INSERT INTO `sys_log` VALUES (6, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":32,\"parentId\":31,\"name\":\"医院列表\",\"url\":\"/business/hospital\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]', 73, '0:0:0:0:0:0:0:1', '2019-08-13 21:46:56');
INSERT INTO `sys_log` VALUES (7, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":32,\"parentId\":31,\"name\":\"医院列表\",\"url\":\"/business/hospital/list\",\"type\":1,\"icon\":\"menu\",\"orderNum\":1}]', 80, '0:0:0:0:0:0:0:1', '2019-08-13 21:47:27');
INSERT INTO `sys_log` VALUES (8, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":33,\"parentId\":31,\"name\":\"科室列表\",\"url\":\"/business/department\",\"type\":1,\"icon\":\"\",\"orderNum\":0}]', 77, '0:0:0:0:0:0:0:1', '2019-08-13 21:49:14');
INSERT INTO `sys_log` VALUES (9, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":33,\"parentId\":31,\"name\":\"科室列表\",\"url\":\"/business/department/list\",\"type\":1,\"icon\":\"dangdifill\",\"orderNum\":2}]', 90, '0:0:0:0:0:0:0:1', '2019-08-13 21:49:40');
INSERT INTO `sys_log` VALUES (10, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":31,\"parentId\":0,\"name\":\"业务管理\",\"type\":0,\"icon\":\"zonghe\",\"orderNum\":1}]', 53, '0:0:0:0:0:0:0:1', '2019-08-13 21:49:57');
INSERT INTO `sys_log` VALUES (11, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[32]', 142, '0:0:0:0:0:0:0:1', '2019-08-13 22:49:01');
INSERT INTO `sys_log` VALUES (12, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[33]', 134, '0:0:0:0:0:0:0:1', '2019-08-13 22:49:13');
INSERT INTO `sys_log` VALUES (13, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[31]', 0, '0:0:0:0:0:0:0:1', '2019-08-13 22:49:17');
INSERT INTO `sys_log` VALUES (14, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[31]', 0, '0:0:0:0:0:0:0:1', '2019-08-13 22:49:24');
INSERT INTO `sys_log` VALUES (15, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[31]', 0, '0:0:0:0:0:0:0:1', '2019-08-13 22:49:37');
INSERT INTO `sys_log` VALUES (16, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":34,\"parentId\":31,\"name\":\"医院表\",\"url\":\"generator/bshospital\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 108, '0:0:0:0:0:0:0:1', '2019-08-13 22:51:16');
INSERT INTO `sys_log` VALUES (17, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":39,\"parentId\":31,\"name\":\"部门表\",\"url\":\"generator/bsdepartment\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 57, '0:0:0:0:0:0:0:1', '2019-08-13 22:51:37');
INSERT INTO `sys_log` VALUES (18, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":34,\"parentId\":31,\"name\":\"医院表\",\"url\":\"bs/hospital\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 75, '0:0:0:0:0:0:0:1', '2019-08-13 22:52:43');
INSERT INTO `sys_log` VALUES (19, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":39,\"parentId\":31,\"name\":\"部门表\",\"url\":\"bs/department\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 98, '0:0:0:0:0:0:0:1', '2019-08-13 22:52:58');
INSERT INTO `sys_log` VALUES (20, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,39,40,41,42,43,-666666]}]', 1816, '0:0:0:0:0:0:0:1', '2019-08-13 22:57:10');
INSERT INTO `sys_log` VALUES (21, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,39,40,41,42,43,-666666]}]', 1928, '0:0:0:0:0:0:0:1', '2019-08-13 22:57:12');
INSERT INTO `sys_log` VALUES (22, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":44,\"parentId\":34,\"name\":\"禁用或启用\",\"url\":\"\",\"perms\":\"bs:hospital:prohibitOrEnable\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 69, '0:0:0:0:0:0:0:1', '2019-08-14 22:44:05');
INSERT INTO `sys_log` VALUES (23, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,-666666]}]', 2004, '0:0:0:0:0:0:0:1', '2019-08-14 22:44:18');
INSERT INTO `sys_log` VALUES (24, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,-666666]}]', 1772, '0:0:0:0:0:0:0:1', '2019-08-14 22:44:21');
INSERT INTO `sys_log` VALUES (25, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":45,\"parentId\":39,\"name\":\"启用或冻结\",\"url\":\"\",\"perms\":\"bs:hospital:prohibitOrEnable\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 73, '0:0:0:0:0:0:0:1', '2019-08-15 00:17:59');
INSERT INTO `sys_log` VALUES (26, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,-666666]}]', 4188, '0:0:0:0:0:0:0:1', '2019-08-15 00:18:11');
INSERT INTO `sys_log` VALUES (27, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,-666666]}]', 2380, '0:0:0:0:0:0:0:1', '2019-08-15 00:18:13');
INSERT INTO `sys_log` VALUES (28, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,-666666]}]', 1804, '0:0:0:0:0:0:0:1', '2019-08-15 00:20:50');
INSERT INTO `sys_log` VALUES (29, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,-666666]}]', 1921, '0:0:0:0:0:0:0:1', '2019-08-15 00:20:51');
INSERT INTO `sys_log` VALUES (30, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":45,\"parentId\":39,\"name\":\"启用或冻结\",\"url\":\"\",\"perms\":\"bs:department:prohibitOrEnable\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 74, '0:0:0:0:0:0:0:1', '2019-08-15 00:21:30');
INSERT INTO `sys_log` VALUES (31, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,-666666]}]', 2262, '0:0:0:0:0:0:0:1', '2019-08-15 00:21:41');
INSERT INTO `sys_log` VALUES (32, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":39,\"parentId\":31,\"name\":\"科室表\",\"url\":\"bs/department\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 11, '115.195.49.46', '2019-08-15 00:29:51');
INSERT INTO `sys_log` VALUES (33, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":46,\"parentId\":31,\"name\":\"部门管理员列表\",\"url\":\"generator/bsdepartmentadministrator\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 66, '0:0:0:0:0:0:0:1', '2019-08-15 23:16:56');
INSERT INTO `sys_log` VALUES (34, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":51,\"parentId\":31,\"name\":\"部门患者表\",\"url\":\"generator/bsdepartmentpatient\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 228, '0:0:0:0:0:0:0:1', '2019-08-15 23:17:25');
INSERT INTO `sys_log` VALUES (35, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":56,\"parentId\":31,\"name\":\"部门患者每日图片\",\"url\":\"generator/bsdepartmentpatientimg\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 65, '0:0:0:0:0:0:0:1', '2019-08-15 23:17:59');
INSERT INTO `sys_log` VALUES (36, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":61,\"parentId\":31,\"name\":\"抽取详情患者\",\"url\":\"generator/bsextractdetailpatient\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 62, '0:0:0:0:0:0:0:1', '2019-08-15 23:18:31');
INSERT INTO `sys_log` VALUES (37, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":66,\"parentId\":31,\"name\":\"抽取处理\",\"url\":\"generator/bsextractdetailpatienthandle\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 69, '0:0:0:0:0:0:0:1', '2019-08-15 23:19:02');
INSERT INTO `sys_log` VALUES (38, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":71,\"parentId\":31,\"name\":\"抽取记录\",\"url\":\"generator/bsextractrecord\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 55, '0:0:0:0:0:0:0:1', '2019-08-15 23:19:33');
INSERT INTO `sys_log` VALUES (39, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":76,\"parentId\":31,\"name\":\"抽取详情\",\"url\":\"generator/bsextractrecorddetail\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 54, '0:0:0:0:0:0:0:1', '2019-08-15 23:19:58');
INSERT INTO `sys_log` VALUES (40, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":81,\"parentId\":31,\"name\":\"患者表\",\"url\":\"generator/bspatient\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 108, '0:0:0:0:0:0:0:1', '2019-08-15 23:20:19');
INSERT INTO `sys_log` VALUES (41, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,39,40,41,42,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,-666666]}]', 3237, '0:0:0:0:0:0:0:1', '2019-08-15 23:21:07');
INSERT INTO `sys_log` VALUES (42, 'admin', '删除定时任务', 'io.renren.modules.job.controller.ScheduleJobController.delete()', '[[1]]', 212, '0:0:0:0:0:0:0:1', '2019-08-16 00:07:32');
INSERT INTO `sys_log` VALUES (43, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":86,\"parentId\":34,\"name\":\"无分页列表\",\"url\":\"\",\"perms\":\"generator:bshospital:listNoPage\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 109, '0:0:0:0:0:0:0:1', '2019-08-17 01:56:51');
INSERT INTO `sys_log` VALUES (44, 'admin', '修改角色', 'io.renren.modules.sys.controller.SysRoleController.update()', '[{\"roleId\":1,\"roleName\":\"超级管理员\",\"remark\":\"超超超级管理员\",\"createUserId\":1,\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,29,30,31,34,35,36,37,38,44,86,39,40,41,42,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,-666666]}]', 6602, '0:0:0:0:0:0:0:1', '2019-08-17 01:57:16');
INSERT INTO `sys_log` VALUES (45, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":87,\"parentId\":39,\"name\":\"医院和科室列表\",\"url\":\"\",\"perms\":\"generator:bsdepartment:getListAndHospital\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 68, '0:0:0:0:0:0:0:1', '2019-08-17 03:16:55');
INSERT INTO `sys_log` VALUES (46, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":88,\"parentId\":81,\"name\":\"获取个人列表\",\"url\":\"\",\"perms\":\"generator:bspatient:getOptionsByName\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 68, '0:0:0:0:0:0:0:1', '2019-08-17 04:38:04');
INSERT INTO `sys_log` VALUES (47, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":89,\"parentId\":81,\"name\":\"获得可抽取数\",\"url\":\"\",\"perms\":\"generator:bspatient:getExtractableNumber\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 76, '0:0:0:0:0:0:0:1', '2019-08-17 13:16:07');
INSERT INTO `sys_log` VALUES (48, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":90,\"parentId\":81,\"name\":\"获得树数据\",\"url\":\"\",\"perms\":\"generator:bspatient:getTreeData\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 110, '0:0:0:0:0:0:0:1', '2019-08-17 20:26:06');
INSERT INTO `sys_log` VALUES (49, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":91,\"parentId\":71,\"name\":\"指定处理\",\"url\":\"\",\"perms\":\"generator:bspatient:extra\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 71, '0:0:0:0:0:0:0:1', '2019-08-18 16:06:28');
INSERT INTO `sys_log` VALUES (50, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":92,\"parentId\":81,\"name\":\"随机抽取\",\"url\":\"\",\"perms\":\"generator:bspatient:randomExtra\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 79, '0:0:0:0:0:0:0:1', '2019-08-18 19:52:20');
INSERT INTO `sys_log` VALUES (51, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":93,\"parentId\":76,\"name\":\"获取记录详情\",\"url\":\"\",\"perms\":\"generator:bsextractrecorddetail:listByRecordId\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 136, '0:0:0:0:0:0:0:1', '2019-08-18 22:12:33');
INSERT INTO `sys_log` VALUES (52, 'admin', '保存菜单', 'io.renren.modules.sys.controller.SysMenuController.save()', '[{\"menuId\":94,\"parentId\":61,\"name\":\"获得详情列表\",\"url\":\"\",\"perms\":\"generator:bsextractdetailpatient:listByDetailId\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 61, '0:0:0:0:0:0:0:1', '2019-08-18 22:43:07');
INSERT INTO `sys_log` VALUES (53, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[61]', 35, '0:0:0:0:0:0:0:1', '2019-08-25 00:25:26');
INSERT INTO `sys_log` VALUES (54, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":94,\"parentId\":71,\"name\":\"获得详情列表\",\"url\":\"\",\"perms\":\"generator:bsextractdetailpatient:listByDetailId\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 67, '0:0:0:0:0:0:0:1', '2019-08-25 00:25:49');
INSERT INTO `sys_log` VALUES (55, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[62]', 156, '0:0:0:0:0:0:0:1', '2019-08-25 00:26:01');
INSERT INTO `sys_log` VALUES (56, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[63]', 104, '0:0:0:0:0:0:0:1', '2019-08-25 00:26:14');
INSERT INTO `sys_log` VALUES (57, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[64]', 108, '0:0:0:0:0:0:0:1', '2019-08-25 00:26:29');
INSERT INTO `sys_log` VALUES (58, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[65]', 143, '0:0:0:0:0:0:0:1', '2019-08-25 00:26:41');
INSERT INTO `sys_log` VALUES (59, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[61]', 146, '0:0:0:0:0:0:0:1', '2019-08-25 00:26:51');
INSERT INTO `sys_log` VALUES (60, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":93,\"parentId\":71,\"name\":\"获取记录详情\",\"url\":\"\",\"perms\":\"generator:bsextractrecorddetail:listByRecordId\",\"type\":2,\"icon\":\"\",\"orderNum\":0}]', 323, '0:0:0:0:0:0:0:1', '2019-08-25 00:30:07');
INSERT INTO `sys_log` VALUES (61, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[77]', 148, '0:0:0:0:0:0:0:1', '2019-08-25 00:30:20');
INSERT INTO `sys_log` VALUES (62, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[78]', 144, '0:0:0:0:0:0:0:1', '2019-08-25 00:30:31');
INSERT INTO `sys_log` VALUES (63, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[79]', 145, '0:0:0:0:0:0:0:1', '2019-08-25 00:30:43');
INSERT INTO `sys_log` VALUES (64, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[80]', 137, '0:0:0:0:0:0:0:1', '2019-08-25 00:30:54');
INSERT INTO `sys_log` VALUES (65, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[76]', 144, '0:0:0:0:0:0:0:1', '2019-08-25 00:31:03');
INSERT INTO `sys_log` VALUES (66, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[57]', 170, '0:0:0:0:0:0:0:1', '2019-08-25 00:31:33');
INSERT INTO `sys_log` VALUES (67, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[58]', 146, '0:0:0:0:0:0:0:1', '2019-08-25 00:31:44');
INSERT INTO `sys_log` VALUES (68, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[59]', 155, '0:0:0:0:0:0:0:1', '2019-08-25 00:31:55');
INSERT INTO `sys_log` VALUES (69, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[60]', 153, '0:0:0:0:0:0:0:1', '2019-08-25 00:32:05');
INSERT INTO `sys_log` VALUES (70, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[56]', 104, '0:0:0:0:0:0:0:1', '2019-08-25 00:32:14');
INSERT INTO `sys_log` VALUES (71, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[67]', 153, '0:0:0:0:0:0:0:1', '2019-08-25 00:37:07');
INSERT INTO `sys_log` VALUES (72, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[68]', 144, '0:0:0:0:0:0:0:1', '2019-08-25 00:37:17');
INSERT INTO `sys_log` VALUES (73, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[69]', 227, '0:0:0:0:0:0:0:1', '2019-08-25 00:37:28');
INSERT INTO `sys_log` VALUES (74, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[70]', 166, '0:0:0:0:0:0:0:1', '2019-08-25 00:37:41');
INSERT INTO `sys_log` VALUES (75, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[66]', 150, '0:0:0:0:0:0:0:1', '2019-08-25 00:37:50');
INSERT INTO `sys_log` VALUES (76, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":46,\"parentId\":31,\"name\":\"科室管理员列表\",\"url\":\"bs/departmentAdministrator\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 12, '115.195.49.220', '2019-08-25 13:33:21');
INSERT INTO `sys_log` VALUES (77, 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '[{\"menuId\":51,\"parentId\":31,\"name\":\"科室患者表\",\"url\":\"bs/departmentPatient\",\"type\":1,\"icon\":\"config\",\"orderNum\":6}]', 58, '115.195.49.220', '2019-08-25 13:33:34');
INSERT INTO `sys_log` VALUES (78, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '[{\"userId\":2,\"username\":\"lalala\",\"salt\":\"GxUs81ygKTDNdSTSKRpM\",\"email\":\"1273022039@qq.com\",\"mobile\":\"15538122563\",\"status\":1,\"roleIdList\":[],\"createUserId\":1}]', 408, '0:0:0:0:0:0:0:1', '2019-08-25 22:51:15');
INSERT INTO `sys_log` VALUES (79, 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '[{\"userId\":2,\"username\":\"lalala\",\"password\":\"f32d497b0a69a9f5bb5af06ca464df1f45438bcfa6da6a160d3dd986a8e81386\",\"salt\":\"GxUs81ygKTDNdSTSKRpM\",\"email\":\"1273022039@qq.com\",\"mobile\":\"15538122563\",\"status\":1,\"roleIdList\":[],\"createUserId\":1}]', 208, '0:0:0:0:0:0:0:1', '2019-08-25 22:51:29');
INSERT INTO `sys_log` VALUES (80, 'lalala', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '[{\"userId\":3,\"username\":\"zhangsan\",\"password\":\"4e5331283dc487272dba029bc05ea1fd348f4e187c31750431c92de0ebb39253\",\"salt\":\"iKqK08yMgyi1X1wD35TN\",\"email\":\"127302039@qq.com\",\"mobile\":\"18298764537\",\"status\":1,\"roleIdList\":[],\"createUserId\":2,\"createTime\":\"Aug 25, 2019 10:57:36 PM\"}]', 320, '0:0:0:0:0:0:0:1', '2019-08-25 22:57:36');
INSERT INTO `sys_log` VALUES (81, 'admin', '删除用户', 'io.renren.modules.sys.controller.SysUserController.delete()', '[[1]]', 2, '0:0:0:0:0:0:0:1', '2019-08-25 23:00:09');
INSERT INTO `sys_log` VALUES (82, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[5]', 0, '0:0:0:0:0:0:0:1', '2019-08-25 23:01:33');
INSERT INTO `sys_log` VALUES (83, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[5]', 0, '0:0:0:0:0:0:0:1', '2019-08-25 23:01:47');
INSERT INTO `sys_log` VALUES (84, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[5]', 245, '0:0:0:0:0:0:0:1', '2019-08-25 23:04:20');
INSERT INTO `sys_log` VALUES (85, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[7]', 132, '0:0:0:0:0:0:0:1', '2019-08-25 23:04:40');
INSERT INTO `sys_log` VALUES (86, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[8]', 199, '0:0:0:0:0:0:0:1', '2019-08-25 23:04:52');
INSERT INTO `sys_log` VALUES (87, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[14]', 173, '0:0:0:0:0:0:0:1', '2019-08-25 23:05:07');
INSERT INTO `sys_log` VALUES (88, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[9]', 169, '0:0:0:0:0:0:0:1', '2019-08-25 23:05:24');
INSERT INTO `sys_log` VALUES (89, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[10]', 193, '0:0:0:0:0:0:0:1', '2019-08-25 23:05:34');
INSERT INTO `sys_log` VALUES (90, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[11]', 197, '0:0:0:0:0:0:0:1', '2019-08-25 23:05:46');
INSERT INTO `sys_log` VALUES (91, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[12]', 144, '0:0:0:0:0:0:0:1', '2019-08-25 23:05:57');
INSERT INTO `sys_log` VALUES (92, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[13]', 157, '0:0:0:0:0:0:0:1', '2019-08-25 23:06:08');
INSERT INTO `sys_log` VALUES (93, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[6]', 135, '0:0:0:0:0:0:0:1', '2019-08-25 23:06:18');
INSERT INTO `sys_log` VALUES (94, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[27]', 131, '0:0:0:0:0:0:0:1', '2019-08-25 23:06:28');
INSERT INTO `sys_log` VALUES (95, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[29]', 132, '0:0:0:0:0:0:0:1', '2019-08-25 23:06:37');
INSERT INTO `sys_log` VALUES (96, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[30]', 138, '0:0:0:0:0:0:0:1', '2019-08-25 23:06:47');
INSERT INTO `sys_log` VALUES (97, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[19]', 142, '0:0:0:0:0:0:0:1', '2019-08-25 23:07:08');
INSERT INTO `sys_log` VALUES (98, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[20]', 256, '0:0:0:0:0:0:0:1', '2019-08-25 23:07:19');
INSERT INTO `sys_log` VALUES (99, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[22]', 146, '0:0:0:0:0:0:0:1', '2019-08-25 23:07:30');
INSERT INTO `sys_log` VALUES (100, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[21]', 129, '0:0:0:0:0:0:0:1', '2019-08-25 23:07:39');
INSERT INTO `sys_log` VALUES (101, 'admin', '删除菜单', 'io.renren.modules.sys.controller.SysMenuController.delete()', '[3]', 134, '0:0:0:0:0:0:0:1', '2019-08-25 23:07:49');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 0);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
INSERT INTO `sys_menu` VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (31, 0, '业务管理', NULL, NULL, 0, 'zonghe', 1);
INSERT INTO `sys_menu` VALUES (34, 31, '医院表', 'bs/hospital', NULL, 1, 'config', 1);
INSERT INTO `sys_menu` VALUES (35, 34, '查看', NULL, 'generator:bshospital:list,generator:bshospital:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (36, 34, '新增', NULL, 'generator:bshospital:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (37, 34, '修改', NULL, 'generator:bshospital:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (38, 34, '删除', NULL, 'generator:bshospital:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 31, '科室表', 'bs/department', NULL, 1, 'config', 2);
INSERT INTO `sys_menu` VALUES (40, 39, '查看', NULL, 'generator:bsdepartment:list,generator:bsdepartment:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 39, '新增', NULL, 'generator:bsdepartment:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (42, 39, '修改', NULL, 'generator:bsdepartment:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (43, 39, '删除', NULL, 'generator:bsdepartment:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (44, 34, '禁用或启用', '', 'bs:hospital:prohibitOrEnable', 2, '', 0);
INSERT INTO `sys_menu` VALUES (45, 39, '启用或冻结', '', 'bs:department:prohibitOrEnable', 2, '', 0);
INSERT INTO `sys_menu` VALUES (46, 31, '科室管理员列表', 'bs/departmentAdministrator', NULL, 1, 'config', 3);
INSERT INTO `sys_menu` VALUES (47, 46, '查看', NULL, 'generator:bsdepartmentadministrator:list,generator:bsdepartmentadministrator:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (48, 46, '新增', NULL, 'generator:bsdepartmentadministrator:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (49, 46, '修改', NULL, 'generator:bsdepartmentadministrator:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (50, 46, '删除', NULL, 'generator:bsdepartmentadministrator:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (51, 31, '住院患者', 'bs/departmentPatient', NULL, 1, 'config', 5);
INSERT INTO `sys_menu` VALUES (52, 51, '查看', NULL, 'generator:bsdepartmentpatient:list,generator:bsdepartmentpatient:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (53, 51, '新增', NULL, 'generator:bsdepartmentpatient:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (54, 51, '修改', NULL, 'generator:bsdepartmentpatient:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (55, 51, '删除', NULL, 'generator:bsdepartmentpatient:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (71, 31, '抽取记录', 'bs/extractRecord', NULL, 1, 'config', 7);
INSERT INTO `sys_menu` VALUES (72, 71, '查看', NULL, 'generator:bsextractrecord:list,generator:bsextractrecord:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (73, 71, '新增', NULL, 'generator:bsextractrecord:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (74, 71, '修改', NULL, 'generator:bsextractrecord:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (75, 71, '删除', NULL, 'generator:bsextractrecord:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (86, 34, '无分页列表', '', 'generator:bshospital:listNoPage', 2, '', 0);
INSERT INTO `sys_menu` VALUES (87, 39, '医院和科室列表', '', 'generator:bsdepartment:getListAndHospital', 2, '', 0);
INSERT INTO `sys_menu` VALUES (91, 71, '指定处理', '', 'generator:bspatient:extra', 2, '', 0);
INSERT INTO `sys_menu` VALUES (93, 71, '获取记录详情', '', 'generator:bsextractrecorddetail:listByRecordId', 2, '', 0);
INSERT INTO `sys_menu` VALUES (94, 71, '获得详情列表', '', 'generator:bsextractdetailpatient:listByDetailId', 2, '', 0);
INSERT INTO `sys_menu` VALUES (96, 31, '出院记录', 'bs/doneDepartmentPatient', '', 1, 'bianji', 6);
INSERT INTO `sys_menu` VALUES (97, 31, '录入信息', 'bs/readCard', '', 1, 'log', 8);
INSERT INTO `sys_menu` VALUES (98, 31, '收费室管理员', 'bs/chargeRoomAdministrator', '', 1, 'tubiao', 4);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '超级管理员', '超超超级管理员', 1, '2019-08-06 17:53:56');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=579 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (495, 1, 1);
INSERT INTO `sys_role_menu` VALUES (496, 1, 2);
INSERT INTO `sys_role_menu` VALUES (497, 1, 15);
INSERT INTO `sys_role_menu` VALUES (498, 1, 16);
INSERT INTO `sys_role_menu` VALUES (499, 1, 17);
INSERT INTO `sys_role_menu` VALUES (500, 1, 18);
INSERT INTO `sys_role_menu` VALUES (506, 1, 4);
INSERT INTO `sys_role_menu` VALUES (507, 1, 23);
INSERT INTO `sys_role_menu` VALUES (508, 1, 24);
INSERT INTO `sys_role_menu` VALUES (509, 1, 25);
INSERT INTO `sys_role_menu` VALUES (510, 1, 26);
INSERT INTO `sys_role_menu` VALUES (524, 1, 31);
INSERT INTO `sys_role_menu` VALUES (525, 1, 34);
INSERT INTO `sys_role_menu` VALUES (526, 1, 35);
INSERT INTO `sys_role_menu` VALUES (527, 1, 36);
INSERT INTO `sys_role_menu` VALUES (528, 1, 37);
INSERT INTO `sys_role_menu` VALUES (529, 1, 38);
INSERT INTO `sys_role_menu` VALUES (530, 1, 44);
INSERT INTO `sys_role_menu` VALUES (531, 1, 86);
INSERT INTO `sys_role_menu` VALUES (532, 1, 39);
INSERT INTO `sys_role_menu` VALUES (533, 1, 40);
INSERT INTO `sys_role_menu` VALUES (534, 1, 41);
INSERT INTO `sys_role_menu` VALUES (535, 1, 42);
INSERT INTO `sys_role_menu` VALUES (536, 1, 43);
INSERT INTO `sys_role_menu` VALUES (537, 1, 45);
INSERT INTO `sys_role_menu` VALUES (538, 1, 46);
INSERT INTO `sys_role_menu` VALUES (539, 1, 47);
INSERT INTO `sys_role_menu` VALUES (540, 1, 48);
INSERT INTO `sys_role_menu` VALUES (541, 1, 49);
INSERT INTO `sys_role_menu` VALUES (542, 1, 50);
INSERT INTO `sys_role_menu` VALUES (543, 1, 51);
INSERT INTO `sys_role_menu` VALUES (544, 1, 52);
INSERT INTO `sys_role_menu` VALUES (545, 1, 53);
INSERT INTO `sys_role_menu` VALUES (546, 1, 54);
INSERT INTO `sys_role_menu` VALUES (547, 1, 55);
INSERT INTO `sys_role_menu` VALUES (563, 1, 71);
INSERT INTO `sys_role_menu` VALUES (564, 1, 72);
INSERT INTO `sys_role_menu` VALUES (565, 1, 73);
INSERT INTO `sys_role_menu` VALUES (566, 1, 74);
INSERT INTO `sys_role_menu` VALUES (567, 1, 75);
INSERT INTO `sys_role_menu` VALUES (573, 1, 81);
INSERT INTO `sys_role_menu` VALUES (574, 1, 82);
INSERT INTO `sys_role_menu` VALUES (575, 1, 83);
INSERT INTO `sys_role_menu` VALUES (576, 1, 84);
INSERT INTO `sys_role_menu` VALUES (577, 1, 85);
INSERT INTO `sys_role_menu` VALUES (578, 1, -666666);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_hospital_manager` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否是医院管理者 0不是 1是 ',
  `hospital_id` bigint(20) DEFAULT NULL COMMENT '关联的医院ID',
  `is_department_manager` tinyint(2) DEFAULT '0' COMMENT '是否是部门管理员 0不是 1是',
  `department_id` bigint(20) DEFAULT NULL COMMENT '管理的部门ID',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13500000001', 1, 1, '2016-11-11 11:11:11', 0, NULL, 0, NULL);
INSERT INTO `sys_user` VALUES (3, 'lpxyy', 'ecc79b1a905405bfa527e008169edf244452c741a0d0c14ce26563cfa4273704', 'lKS7U8nlHCOItxAyKuYo', '', '', 1, 1, '2019-10-01 23:40:07', 1, 5, 0, NULL);
INSERT INTO `sys_user` VALUES (4, 'lpzyy', 'c939791873a3cd90dce7e6d56329d9667ad91f1faaff5dda46bc9dd01d9fd5f0', 'G6wDH5l56kDX1Xtj4XHB', '', '15097891500', 1, 1, '2019-10-07 09:34:00', 1, 4, 0, NULL);
INSERT INTO `sys_user` VALUES (5, 'lpzhenyiyuan', 'd146cabbf2db9439bc33e852251074f5bbf447fa907d9fe94e0b0c23d2efd8c4', 'Rfv2M2l2NxAhZfjYkNLf', '', '', 1, 1, '2019-10-10 16:49:39', 1, 7, 0, NULL);
INSERT INTO `sys_user` VALUES (6, 'lpfyyy', 'cabbf513f1ba3c36a244740ec95acbc4b9a84df89eb7f2072164a30fcf763f2f', 'zsVdvwGTw3GVtnb3mF0f', '', '', 1, 1, '2019-10-10 16:50:26', 1, 8, 0, NULL);
INSERT INTO `sys_user` VALUES (8, 'ce', '6cbfe9da0572d958a60a651b67ea16da35e3780272e6634b6f6f3ff9337999db', 'DkgpgS3ADhkQL6KVGY4j', '', '', 1, 1, '2019-10-16 00:14:09', 0, 4, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (2, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES (1, '9600bedb9f3463a83cb0a549d22df483', '2020-01-02 03:52:02', '2020-01-01 15:52:02');
INSERT INTO `sys_user_token` VALUES (2, 'c8cfa6f042f173dcaa4a2e2c05fe9e25', '2019-08-26 10:52:25', '2019-08-25 22:52:25');
INSERT INTO `sys_user_token` VALUES (3, 'e95ef090adcfbe6ab545e642263fa549', '2019-10-14 01:20:09', '2019-10-13 13:20:09');
INSERT INTO `sys_user_token` VALUES (4, '223adb4790faf97fa0769cf93a79bf75', '2019-10-14 01:20:43', '2019-10-13 13:20:43');
INSERT INTO `sys_user_token` VALUES (5, 'aff9d61d071f2c6147d4418a54d9d355', '2019-10-15 08:30:46', '2019-10-14 20:30:46');
INSERT INTO `sys_user_token` VALUES (6, 'ef43ffdf577e5c4f4e89d562a0e6f08a', '2020-01-05 04:58:10', '2020-01-04 16:58:10');
INSERT INTO `sys_user_token` VALUES (7, '945e51f83a873844c88381a3a94d3ce2', '2019-10-16 11:56:31', '2019-10-15 23:56:31');
INSERT INTO `sys_user_token` VALUES (8, 'bdb7fd306772ea08d334f9acde44e4e9', '2019-10-17 09:18:42', '2019-10-16 21:18:42');
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
